About this tutorial:
Video duration: 10:25
Download Excel File:
See how to:
1. (00:08 minute mark) Problem Set Up
2. (00:55 minute mark) Excel 2013 PivotTable and “Add to Data Model” to get Distinct Count Formula
3. (02:38 minute mark) Remove Duplicates, Screen Tip Trick and COUNT function
4. (03:42 minute mark) Array Formula with MATCH, Concatenated Columns, FREQUENCY Array Function, IF and SUM function. Learn that because we use FREQUENCY function to generate Array, we do not need Ctrl + Shift + Enter when we put FREQUENCY in IF and SUM functions.