Hi all,

I'm trying to get the min and max for a list of ZIP codes in column A relative to a list of numbers in column B. The ZIPs go in sequential order and cover the entire United States. The numbers in column B are related to different ranges of ZIP codes - for instance, ZIPs 00001 through 00015 may have the number 0.00255 associated with them, 00016 may have -0.3215, and 00017-00018 may have the same number associated with it as 00001-00015.

What I need to do, given the example above, is to make three new columns where the first column has 00001 as the min, the second column has 00015 as the max, and the third column has 0.00255. Therefore, in the next row I would need to have 00016 as both the min and the max and have -0.3215 in the third column, and in the third row the min is 00017, the max is 00018, and the number is 0.00255.

I know this is possible because I've seen it done, but I'm not amazing with formulas. I really appreciate any help you can provide. Thanks in advance!