Excel Magic Trick 1053: Unique Count With Criteria: Excel 2013 PivotTable Distinct Count Function

Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm
Amazing New Excel 29013 feature to count unique items with criteria:
1. In Excel 2013 the New PivotTable Function Distinct Count can replace complicated Array Formulas.
2. The Distinct Count function in a 2013 PivotTable will ONLY APPEAR if you check the “Add this data to Data Model” in the Create PivotTable dialog box.
3. The Data Model is part of the PowerPivot engine and rthis works EVEN if you don’t have PowerPivot.
4. Once you create your pivot table: 1) Drop field you want to make a unique count upon into the…

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 *