Senior moment!
That should read =COUNTIF($A$1:A1,A1)
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Papa Cricket" <Papa wrote in message
...
I am looking to count how many times a number appears in a column beside
that
number as you go down that column. Beside the first occurance of the
number
10 the cell in the column beside it would have a 1, the next occurance of
the
number 10 the cell in the column beside it would have a 2, and so on.
Thank
you in advance for your help.