Hi
You basically want to add the largest and smallest values together. If the
data is in column B type the numbers 1, 2, 3, 4, 5 in column D
In E1 type =LARGE($B$1:$B$9,D1)+SMALL($B$1:$B$9,D1) and copy down to line 4.

In E5 you want the median value =MEDIAN(B1:B9) you can add this to the
smallest sum row 4

Regards
Peter

"LeodaQ" wrote:

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?