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

Thanks, that worked perfectly

"kraljb" wrote:


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