Thread: Find Largest and Return Column Name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kraljb
 
Posts: n/a
Default Find Largest and Return Column Name

Assuming that your Column Titles are in Row1 and that Data begins Row2
=INDEX(A1:D1,0,MATCH(MAX(A2:D2),A2:D2,0))


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=523634

Reply With QuoteReply With Quote