i need the column header of the largest value in a row. I figured I could use Index Match with Max. It worked but I realized that the different spreadsheets are ranked differently. So I need the column header for the largest value in a row for a specific row.
1 Answers
You already know how to find the column number, using Index and Match. It should not be too hard to find the header title, using Range(1,Found_Column). (I suppose your header titles are on the first row?)
Related