View Single Post
  #1   Report Post  
anilsolipuram
 
Posts: n/a
Default 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