Download Excel File: https://excelisfun.net/files/EMT1710.xlsx
Learn how lookup the last invoice payment date from a data set based on an invoice number. See 5 examples that can work in any version.
Topics:
1. (00:00) Introduction.
2. (00:20) MAXIFS function solution. Excel 2016 or later.
3. (01:42) AGGREGATE function solution. Excel 2010 or later.
4. (04:18) MAXIFS Spilled Array solution. Excel 365.
5. (05:24) Use an Excel Table to make everything dynamic.
6. (05:47) SORT, UNIQUE and MAXIFS Spilled Array solution. Excel 365.
7. (06:41) PivotTable solution. Works in any version.
8. (07:43) Summary, Closing and Video Links