Formula to Write header of highest value in row

swjtx99
swjtx99 used Ask the Experts™
on
Hi, Please see attached. I am looking for a formula that will look at the values in a row and write whatever is in the header of the highest value to a cell.  Kind of hard to explain so I included an example file.
TestExample.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mechanical Engineer
Most Valuable Expert 2013
Top Expert 2013
Commented:
Here are two possible formulas. In case of a tie, the first one returns the last column header while the second one returns the first column header. Both formulas are designed to be put in a cell in row 2, then copied down.
=LOOKUP(MAX(A2:E2),A2:E2,A$1:F$1)
=INDEX(A$1:E$1,MATCH(MAX(A2:E2),A2:E2,0))

Open in new window

TestExampleQ29164333.xlsx

Author

Commented:
Thank you sir. Very helpful.

swjtx99

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial