If I understand your question well, maybe like this.
A B C D E F 1 result 2 1 16 4 9 16 3 8 3 2 1 8 4 11 5 9 6 11 Blad9
Worksheet Formulas
Cell Formula F2 =MAX(A2:D2)
This is a discussion on Lookup a column of values with the largest sum within the Excel Questions forums, part of the Question Forums category; Hi there, Hope this post finds you well. I need to lookup cells from one of four columns, and place ...
Hi there,
Hope this post finds you well.
I need to lookup cells from one of four columns, and place them in a new column. The lookup columns are p/l columns and I'm looking for the column with the max sum. So if column b has the max sum I want all the cells from that column to show up in column x.
Kind Regards
Per
If I understand your question well, maybe like this.
A B C D E F 1 result 2 1 16 4 9 16 3 8 3 2 1 8 4 11 5 9 6 11 Blad9
Worksheet Formulas
Cell Formula F2 =MAX(A2:D2)
I understood the request differently than Oeldere...
Row\Col A B C D E F G 1X1 X2 X3 X4 2 2 1 16 4 9X2 3 8 3 2 1 16 4 11 5 9 6 3 5 5 6
In G1 control+shift+enter, not just enter:
=MATCH(MAX(MMULT(TRANSPOSE(A2:D4),ROW(A2:D4)^0)),MMULT(TRANSPOSE(A2:D4),ROW(A2:D4)^0),0)
In G2 just enter:
=INDEX(A1:D1,G1)
In G3 just enter and copy down:
=IFERROR(INDEX($A$2:$D$4,ROWS($G$3:G3),$G$1),"")
Assuming too much and qualifying too much are two faces of the same problem.
Hey, thanks a lot guys!
You nailed it Aladin.
Kind regards
/Per
Aladin,
I'm using this in a table importing csv files.
Is there a workaround so I can get this function on the same row?
As for now I'm missing out the last number in the table.
Kind regards
/Per
I only implemented the setup to my sheet of imported data.
I'll build #3 and see if I'll get the same problem.
Like this thread? Share it with others