This is for a colleague who’s visiting us here at the Free Market Institute…
He as data in Excel with Year in Column A, and then items of interest in B through M (or whatever).
Now, at the very bottom, after the last year, he wants to have a row that returns the *year* of the MAX value in each column.
So for example, if row 100 is the last Year of 2014, then row 101 would say, “Max in Year:” and then in Column B, it might say “1984” while in Column C, it might say “1977.” That means that if you look at Column B, the max value occurred in Year 1984, etc.
So, what’s the easiest way for him to get Excel to populate that bottom row?