Hello,
I'm trying to pull the column and row header values that correspond with the max value in the table. In this case the value of "20" in cell E3. I would like the corresponding row header "2" to show up in cell B8 and corresponding column header "4" to be in cell B9. The values will change whenever I update the table so the max value will move each time I update. I appreciate the help.
I'm trying to pull the column and row header values that correspond with the max value in the table. In this case the value of "20" in cell E3. I would like the corresponding row header "2" to show up in cell B8 and corresponding column header "4" to be in cell B9. The values will change whenever I update the table so the max value will move each time I update. I appreciate the help.
Excel 2012 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | 1 | 2 | 3 | 4 | 5 | |||
2 | 1 | 2 | 10 | 5 | 4 | 3 | ||
3 | 2 | 4 | 5 | 11 | 20 | 16 | ||
4 | 3 | 3 | 2 | 1 | 8 | 6 | ||
5 | 4 | 15 | 7 | 12 | 3 | 2 | ||
6 | 5 | 9 | 5 | 13 | 4 | 17 | ||
7 | ||||||||
8 | ||||||||
9 | ||||||||
Sheet1 |