|
|
|
|
#1
12-11-2014, 10:14 PM
|
|||
|
|||
Arranging x numbers in y groups with an approximate sum of z
I have ''x'' set of numbers (say { 1.3, 2.7, 3.8, 1.9, 8.2, 1.5, 18.4, 22, 5.3}) which I want to group in ''y'' (say 3) sets with each set totaling to an approximate value of ''z'' (say 7). How can i do this using excel? 
|
|
| Tags |
| grouping, rearrange |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Re-arranging data output into useable format | bremen22 | Excel | 2 | 11-18-2013 10:32 AM |
| Bar Graph in Groups | Alaska1 | Excel | 3 | 12-17-2012 05:20 PM |
| Effects list re-arranging | Buzzman | PowerPoint | 0 | 11-21-2011 08:46 PM |
 Arranging Into Groups
|
skoz55 | Excel | 1 | 09-07-2011 12:02 AM |
| Some contacts are listed in groups I don't want | ironwoods | Outlook | 0 | 07-29-2010 04:40 PM |
Windows 7 32bit 
Office 2013
Hybrid Mode