Excel Magic Trick 1153: Unique Count For Name & Date: Array Formula, 2013 PivotTable, More…




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.

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

Leave a Reply

Your email address will not be published. Required fields are marked *