View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LeodaQ LeodaQ is offline
external usenet poster
 
Posts: 2
Default 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?