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!