Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to use functions after sorting a range? | Excel Worksheet Functions | |||
Sorting a Range | Excel Discussion (Misc queries) | |||
sorting a range | Excel Discussion (Misc queries) | |||
Sorting a Concatenated Range | Excel Worksheet Functions | |||
Sorting names in a range | Excel Worksheet Functions |