How do I reformat data into ranges
 

I have an Exel file with 2 columns. The 1st column has over 40,000 different
values, the 2nd has only 5. I need to create ranges showing the Column A
values in ranges, i.e 1 thru 250=1. 251 thru 750=2. 750 thru 1250=1 etc. How
can this be done?

How do I reformat data into ranges
 

Hi Jerry,

You can use a series of COUNTIF formulae for this. For example:
=COUNTIF(A:A,"<250") returns the count of items less than or equal to 250
whilst
=COUNTIF(A:A,"<=250") returns the count of items less than 250
and
=COUNTIF(A:A,"<500")-COUNTIF(A:A,"<250") returns the count of items equal to or greater than 250 but less than 500
and
=COUNTIF(A:A,"<=500")-COUNTIF(A:A,"250") returns the count of items greater than 250 but less than or equal to 500.

--
Cheers
macropod
[MVP - Microsoft Word]


"Jerry" wrote in message ...
I have an Exel file with 2 columns. The 1st column has over 40,000 different
values, the 2nd has only 5. I need to create ranges showing the Column A
values in ranges, i.e 1 thru 250=1. 251 thru 750=2. 750 thru 1250=1 etc. How
can this be done?