I've got a spreadsheet with about 5,000 rows and roughly 50 columns. The columns are alternating between terms and numeric values associated with the terms (example: baseball / 1000 / football / 500 / soccer / 600 / hockey / 750 / track / 100).
To the right of all of the columns, I'd like to add a summary column that selects the highest value and returns that value's associated term.
MAXA for finding the highest value (
=maxa(A1:J1)) and I believe INDIRECT is a good way to return the word(s) in the cell directly to the left of the highest value cell (
What I can't figure out is how to combine
INDIRECT or nest them so they'll work together.