Hi All,
This is my issue:
I have a range of value that is in a single row.
I need to calculate the maximum of every other cell and return the value/text on the cell aside.
Example
1 text 1 2 text 2 3 text 3 4 text 4 5 Text 5
In this specific example I need to calculated the max of cells 1,3,5,7,9 and return the value/text of the cell on the right (2 or 4 or 6 or 8 or 10) for the one that is maximum.
In this instance the result would be "text 5"
I tried with VLOOKUP and the MAX but I can only have the specific column in the array, not the column at the very right.
Anybody has idea?
Thanks,
Andrea
Bookmarks