counting recurring #'s in a column
 

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

counting recurring #'s in a column
 

Hi

With data in column A, enter in B1
=COUNTIF(A:A,A1)
and copy down

--
Regards
Roger Govier



"okie7392" wrote in message
...
I am trying to count the number of times each # within a column repeats
it's
self.
I am completely lost!

counting recurring #'s in a column
 

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

On Sun, 18 Nov 2007 09:59:00 -0800, okie7392
wrote:

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