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

If I understand correctly you need to type

=INDEX($A$2:$A$6,MATCH(MAX(B2:B6),B2:B6,0))

then you can copy the formula down the list.

"DeeZi" wrote:


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

maybe...

=INDEX($A$2:$A$6,MATCH(MAX(B$2:B$6),B$2:B$6,0))

And drag across.

DeeZi wrote:

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

--

Dave Peterson