Maybe I'm not understanding correctly, but if you follow this if statement it
can give you what you stated below.

=IF(A1<1001,1,IF(A1<1251,2,IF(A1<2501,3,IF(etc.))) )

This what you're looking for?
--
-SA


"Jerry" wrote:

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