Original Question:
I need a function fo r the following:
In a given row of # values, I want to find the max. value and give the
associated text column heading in a new column. How do I do this??
Thanks
Original Answer:
With your headings in A1:Z1 and your numbers in A2:Z2
=INDEX(A1:Z1,MATCH(MAX(A2:Z2),A2:Z2),0)
This worked, but how can I reference more than one column heading
should there be multiple cells that equal the max value?
Thanks
--
xxxMarkxxx
------------------------------------------------------------------------
xxxMarkxxx's Profile:
http://www.excelforum.com/member.php...o&userid=29401
View this thread:
http://www.excelforum.com/showthread...hreadid=491169