Thread: how do I Count repeating numbers in the previous column?
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default how do I Count repeating numbers in the previous column?
PIVOT table is a right tool for this. No formula is required.


"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?
Reply With QuoteReply With Quote