D
DeeZi
let's say I have
A B C D
1 2 4 4
2 5 2 6
3 4 7 2
4 2 6 3
5 3 9 8
Now I do =INDEX(A2:A6,MATCH(MAX(B2:B6),B2:B6,0)) and I want to continu
doing it for columns C and D, but having it correspond back to the
column. So for example, the max of B is 5 corresponding to 2 in the
column. Max is C corresponding to 5 in the A column. I have a whol
bunch of columns and I wanted to copy the formula above but it onl
does it with columns next to each other. How can I get it so that i
keeps referring back to the A column but reads other columns instead o
manually changing each one.
Thanks again
A B C D
1 2 4 4
2 5 2 6
3 4 7 2
4 2 6 3
5 3 9 8
Now I do =INDEX(A2:A6,MATCH(MAX(B2:B6),B2:B6,0)) and I want to continu
doing it for columns C and D, but having it correspond back to the
column. So for example, the max of B is 5 corresponding to 2 in the
column. Max is C corresponding to 5 in the A column. I have a whol
bunch of columns and I wanted to copy the formula above but it onl
does it with columns next to each other. How can I get it so that i
keeps referring back to the A column but reads other columns instead o
manually changing each one.
Thanks again