This worked for the numbers shown. But when I copied it down the next counts
were 15, 6 and 27, but the formula gave me "0" for each. ???

"T. Valko" wrote:

Try this:

=IF(A2=A3,"",COUNTIF(A$2:A$12,A2))

Copy down as needed

--
Biff
Microsoft Excel MVP


"Texas Nuckols" wrote in message
...
I have this set up:

Market Count
1501
1501
1501
1501
1501 5
1506
1506
1506 3
1507
1507
1507 3

I did this manually for a file of over 1000 lines. Now I need to do the
same thing for a file of 5000 lines. The file is sorted by "Market". I
just
need to create a formula that will Count the numbers repeated in column A
and
put the answer in column B. Can you help?