| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Disribute a group of numbers among four cells
I have a group of numbers that need to be distributed into four groups so
that the sum of the numbers in each of the four groups is as equal as possible. E.G., if I had this group of numbers: 26, 45, 99, 33, 45.5, 66.67, 15, 110.15 & 76.33 how would I break these 9 numbers into 4 groups so that each of the groups had a sum as close as possible to the other groups? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating only non-empty cells... | Excel Worksheet Functions | |||
| Formula to return a value if any numbers in a group meet a criteri | Excel Worksheet Functions | |||
| How to format cells to recognize numbers like 1.1.1? | Excel Discussion (Misc queries) | |||
| question about removing text from cells, leaving numbers | Excel Discussion (Misc queries) | |||
| check if 2 cells are equal but only if they contain numbers not i. | Excel Worksheet Functions | |||
Threaded Mode
