Download Excel File: https://excelisfun.net/files/EMT1794.xlsx
Learn how to lookup cell address to maximum value with 12 different formulas.
Topics:
1. (00:00) Introduction
2. (00:15) Conditional Formatting for Biggest Value.
3. (00:36) Formula #1 with the functions: MAX, ADDRESS, XMATCH, ROW and COLUMN.
4. (01:56) Formula #2 with the functions: MAX, ADDRESS, XMATCH and COLUMN.
5. (02:24) Formula #3 with the functions: XLOOKUP, MAX and CELL.
6. (03:34) Formula #4 with the functions: LET, XLOOKUP, MAX, ADDRESS, ROW and COLUMN.
7. (03:56) Formula #5 with the functions: LET, INDEX, XMATCH, MAX, ADDRESS, ROW and COLUMN.
8. (04:06) Formulas #6-10 with the functions: Old School Formulas that will work in any version of Excel.
9. (04:17) Formula #11 with the functions: LET, MAX, COLUMN, ROW, TEXTJOIN, IFERROR, ADDRESS. This formula works when there are duplicates and can work on either a column of values or a table of values.
10. (09:12) Formula #12 with the functions:
11. (09:23) Summary
12. (09:37) Closing, Video Links