Glad I was of assistance. I'm glad you got it working. In the future, if you
want "Can you write the formula using the data in my example?", you need to
tell us *where* your data is. It's true you told us your data was in column
A, but you didn't say what row it started on. So we either take our best
guess, or give examples which you have to modify to suit your situation.

We would much rather give the exact formula, but are more often than not
stymied by the lack of information in the original post.

Regards,
Fred.


"Texas Nuckols" wrote in message
...
I guess I don't give myself enough credit. I copied over your formula
exactly as below and it worked beautifully! Thank you for all the hours
of
work you saved me!!!

"Fred Smith" wrote:

You want Countif. In b1, put:
=countif(a:a,a1)
Copy down to the end of column A (you can do this by double-clicking on
the
fill handle).

If you want the entry in column B to appear only when there's a change in
column A, use something like:
=if(a1=a2,"",countif(a:a,a1))

Regards,
Fred

"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?