counting recurring #'s in a column

O

okie7392

I am trying to count the number of times each # within a column repeats it's
self.
I am completely lost!
 
G

Gord Dibben

If you know the unique numbers you can use the FREQUENCY function.

Say you have the numbers 1 through 9 multiple times randomly in A1:A50

In B1:B9 enter numbers 1 to 9

Select C1:C9

In C1 enter =FREQUENCY(A1:A50,B1:B9) then hit CTRL + SHIFT + ENTER


Gord Dibben MS Excel MVP
 
Top