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.
Quote:
Originally Posted by Gord Dibben
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!
|