Uploaded November 2015 | Updated September 2026, 9 minutes ago

---

Get Excel file 00140 here: http://1drv.ms/1bYwrTa

Show the row & column headers for the max values in a range.

(00:00) Original idea from Tom Urtis
(00:10) Requirement explanation
(00:44) HOMEWORK: Why doesn't it work if there are ties?
(01:13) Side note: Four ways to count how many max values
(01:53) SOLUTION EXPLANATION (no massive multi line formula)

Please add your solution as a comment below the video!!!

Cheers,
Kevin Lehrbass
twitter.com/kevinlehrbass
myspreadsheetlab.com/blog