Creating a column with index names from other columns

[juansalix]

Hello,

I'm guessing the process I'd like to undertake involves the functions MAX and INDEX, although I'm not sure how to implement both in the same formula.

I've attached a sample of my data. In column K, I would like to have the name of one of the column headers from [F1:K1] which has the maximum value for each row.

I've attached a second file "sample_output" which shows how the output file should look like.

Hope this question was interesting. Any input is appreciated!

[Pete_UK]

You can use this formula in K2:

=INDEX($F$1:$J$1,MATCH(MAX(F2:J2),F2:J2,0))

Note that you may have to use semicolons ( ; ) instead of commas ( , ) in the formula, depending on your regional settings.

Copy the formula down as required.

Hope this helps.

Pete

[Pete_UK]

Thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete