Thread: How do I consolidate data into ranges
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jerry Jerry is offline
external usenet poster
  
Posts: 142
Default How do I consolidate data into ranges
I need to consolidate data from 2 columns. Column A has over 40,000 unique
values, Column B has only 5. I need to consolidate Column A into ranges. I.e.
1 thru 1000 = 1. 1001 thry 1250 = 2. 1251 thru 2500 = 1. etc.
Thanks
Reply With QuoteReply With Quote