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 continue
doing it for columns C and D, but having it correspond back to the A
column. So for example, the max of B is 5 corresponding to 2 in the A
column. Max is C corresponding to 5 in the A column. I have a whole
bunch of columns and I wanted to copy the formula above but it only
does it with columns next to each other. How can I get it so that it
keeps referring back to the A column but reads other columns instead of
manually changing each one.
Thanks again!
--
DeeZi
------------------------------------------------------------------------
DeeZi's Profile:
http://www.excelforum.com/member.php...o&userid=24805
View this thread:
http://www.excelforum.com/showthread...hreadid=383685