Hi, I need a bit of help to find the last column header in of the maximum value in row of cells when the max is duplicated.
The index match function gives me the first column header of the first max value, but I want the column header of the last occurrence of the max value. So, in the above example, I want a formula that will give me tb01 for a2, tb01 for a3 and tb03 for a4.
Any ideas on how to do that. I have an older version of excel and maxifs functions don't work.
Thanks
Max tb | tb00 | tb01 | tb02 | tb03 |
=INDEX($b$1:$e$1,0,MATCH(MAX($b2:$e2),$b2:$e2,0)) | 120 | 130 | 120 | 120 |
130 | 130 | |||
125 | 100 | 100 | 125 |
The index match function gives me the first column header of the first max value, but I want the column header of the last occurrence of the max value. So, in the above example, I want a formula that will give me tb01 for a2, tb01 for a3 and tb03 for a4.
Any ideas on how to do that. I have an older version of excel and maxifs functions don't work.
Thanks