ExcelBanter - MAX Function and Corresponding Column

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - MAX Function and Corresponding Column (https://www.excelbanter.com/excel-discussion-misc-queries/31412-re-max-function-corresponding-column.html)

anilsolipuram

MAX Function and Corresponding Column

You have to use large function for this

=INDEX($A$1:$C$1,1,MATCH(LARGE(A2:C2,2),A2:C2,0))

--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=349528

All times are GMT +1. The time now is 10:32 AM.