Frequency of a number

[leovilla64]

Frequency of a number

Hello, I would like to know how often one nr appears along with another.

Best regards
Leo

[Leith Ross]

Hello Leo,

Put this formula in B3 and drag it down to B53...

=COUNTIF($C$3:$V$11,A3)

[mdmackillop]

... and if you wish to show the "x" then use a custom number format of: 0"x"

[leovilla64]

Thankful for the attention, but what I wanted to do is that when the number 3 that I used as an example (B1) appears in a line how many times it coincides with the other numbers. In the example I used the 7 that appears 2 times.

[mdmackillop]

In B3 and copy down
=freq(A3,$B$1,$C$4:$V$11)
In standard module

Function Freq(x, y, data)
Dim Rw As Range, a As Long
For Each Rw In data.Rows
a = a + (Not Rw.Find(x, lookat:=xlWhole) Is Nothing) * (Not Rw.Find(y, lookat:=xlWhole) Is Nothing)
Next
If x = y Then
Freq = "#N/A"
Else
Freq = a
End If
End Function

[leovilla64]

Grateful for the attention, that's what I needed.