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…