Find highest value, return entire column.

[steele76]

Hi,

I have a spreadsheet with a number of columns and below each column is the sum of the cells in each column.
I would like a function that searches for the highest sum and then return the entire column above that sum in a new column.

test.JPG

Does anyone have an idea what I can do?

/John

[Special-K]

in F7
=MAX($A$7:$C$7)

in F1
=OFFSET($A1,0,MATCH(MAX($A$7:$C$7),$A$7:$C$7,0)-1)
and copy down

[bebo021999]

Another solution, in F1 then drag down:

=LOOKUP(2,1/(MAX($A$7:$D$7)=$A$7:$D$7),A1:D1)