This is what I have:

Zipcodes Transit time
00501 5
00502 5
00503 5
11001 1
11002 1

I need to replace this with:

Zipcode Ranges Transit Time
00501 - 00503 5
11001 - 11002 1

Thank you for all your assistance

"StumpedAgain" wrote:

Perhaps a quick "this is what I have" and "this is what I want" would help.
I.e.

What I have:
Zipcodes Transit Times
94534 4
65481 5
etc.

What I want:
??

I guess I'm confused on what you're looking to get out of it. Do you want a
count of all the ranges between certain values? How are you looking to
consolidate these zip codes?

I'm not sure this is what you're looking for but perhaps a slight
modification to what I posted befo

=IF(A1<1001,"1-1000",IF(A1<1251,"1001-1250",IF(A1<2501,"1251-2500",IF(etc.))))

Let me know!
--
-SA


"Jerry" wrote:

The figures 1 thru 1000 were an example, I need a formula to create the
actual range based on the value in Column B.

"StumpedAgain" wrote:

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