Download Excel File: https://excelisfun.net/files/EMT1767.xlsx
Learn how to count unique dates for each item four ways: PivotTable and DAX Implicit Measure, Spilled Array Formulas, FREQUENCY Function and LAMBDA function.
1. (00:00) Introduction
2. (00:18) Goal of unique count formula
3. (00:30) Data Moel PivotTable solution with DAX formula Implicit Measure
4. (03:03) Microsoft 365 or Excel 2021 Solution. See the functions: SORT, UNIQUE, FILTER, COUNT. This formula requires a copy action.
5. (05:11) Solution that works in any version of Excel
6. (05:53) Dynamic Spilled Array Solution for the aggregate unique count solution using BYROW and LAMBDA functions. Only works in Microsoft 365 Excel.
7. (08:45) Refresh to update PivotTable
8. (09:07) Conclusion
9. (09:30) Closing and Video Links