Hi,

I have a column (A) of values which I want to split into 3 columns.

The sum of each of the 3 columns must be as 'balanced' / near equal to each other as is possible.

e.g. if column (A) had the values:

17 17 18 17 18 18

then the 3 columns would each be:

17,18 = 35
17, 18 = 35
17, 18 = 35

(that's an oversimplified example. Column (A) will have many more values and they could be anything)

is this possible in excel & if so can anybody help?

much appreciated