Sorting by range
 

Hi everyone!

I'm looking for hints on the following:
I have a list with a large number of values and I would like to sort these into four groups by size.

Thanks in advance!

Sorting by range
 

And what would be the lower and upper ranges of size?

Or you just want 4 equal sized groups?

Like 1 through 12 would be grouped 1-4, 5-8 amd 9-12


Gord Dibben MS Excel MVP

On Sat, 20 Oct 2007 11:50:41 +0100, planetdust wrote:


Hi everyone!

I'm looking for hints on the following:
I have a list with a large number of values and I would like to sort
these into four groups by size.

Thanks in advance!

The groups would be minimum value to 1/4 of the max. value, 1/4 of the max. value to 2/4 of the max. value, 2/4 of the max. value to 3/4 of the max. value, and finally 3/4 of the max. value to the max. value. I suppose, that the number of values that end up in each group will be different.
Sorting in ascending order by size shows, that the minimum value in this specific list is 0,01841 and the max. is 0,05388.

Sorting by range
 

Perhaps you can use MAX to find the largest number in your range, MIN
to find the smallest number, so the difference between these will give
you the total range of numbers. Dividing by 4 will give you the range
of numbers within each group (if you wanted to categorise them this
way). So, if your minimum was -10 and your maximum was 200, each group
would be (200 - -10)/4 wide, i.e. 210/4 or 52.5. So, your first group
would be from -10 to 42.5, second group 42.5 to 95, third group 95 to
147.5 and final group 147.5 to 200.

Of course, you might want to group them by frequency and have the same
number of values within each group ...

Hope this helps.

Pete

On Oct 20, 11:50 am, planetdust wrote:
Hi everyone!

I'm looking for hints on the following:
I have a list with a large number of values and I would like to sort
these into four groups by size.

Thanks in advance!

--
planetdust