Excel Magic Trick 1153

Unique Count For Name & Date: Array Formula, 2013 PivotTable, More…

DESCRIPTION

See how to:
(00:08) Problem Set Up
(00:55) Excel 2013 PivotTable and “Add to Data Model” to get Distinct Count Formula
(02:38) Remove Duplicates, Screen Tip Trick and COUNT function
(03:42) 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.




Be the first to comment

Leave a Reply