Your data appears to already be sorted by market number, inteh furture you
might try the subtotal feature, just change from default of "sum" to "count".

HTH

"Texas Nuckols" wrote:

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?