Thread: how do I Count repeating numbers in the previous column?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Texas Nuckols Texas Nuckols is offline
external usenet poster
  
Posts: 10
Default how do I Count repeating numbers in the previous column?
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?
Reply With QuoteReply With Quote