 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2007Sorting 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!  Signatureplanetdust 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 >Hi everyone! > [quoted text clipped - 3 lines] > >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. Gord Dibben;573582 Wrote: > And what would be the lower and upper ranges of size? > [quoted text clipped - 13 lines] > > > >Thanks in advance!- Signatureplanetdust 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 > Hi everyone! > [quoted text clipped - 6 lines] > -- > planetdust |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.