Sign up for our Excel webinar, times added weekly: excelcampus.com/blueprint-registration/
In this video, you can see two different ways to calculate distinct count in a data set using Pivot Tables. These are two solutions to a Data Analysis Challenge that I gave to viewers.
You can download the example Excel files and read the full article here:
excelcampus.com/pivot-tables/distinctcount-pivot-tables.
Related Videos:
Excel Data Analysis Challenge - Count Transactions with Multiple Rows:
youtube.com/watch?v=_3lX1NwIfzQ
Introduction to Pivot Tables, Charts, and Dashboards in Excel:
youtube.com/watch?v=9NUjHBNWe9M&t=5s
Refresh Pivot Table Automatically when Source Data Changes:
youtube.com/watch?v=NI1UQcYtl1A
5 Reasons to Use an Excel Table as the Source of a Pivot Table: excelcampus.com/tables/table-source-pivot-table/
#MsExcel #ExcelCampus
00:00 Introduction
00:50 Pivot Table Solution
05:33 Power Pivot Solution
- 2 Quick Ways To Calculate Distinct Count With Pivot Tables ( Download)
- Two ways to do distinct count in pivot table (MS Excel) ( Download)
- Excel Distinct Count with a PivotTable ( Download)
- Count Unique Values in PivotTables in Excel ( Download)
- Excel PivotTable: Count Unique Records | Distinct Count in Excel PivotTable ( Download)
- How to add unique count to a pivot table ( Download)
- Distinct Count with a PivotTable in Excel by Chris Menard ( Download)
- Easy way to get Distinct Count in Pivot Tables ( Download)
- How To Count Unique Items In Pivot Table In Excel ( Download)
- How to get Distinct Count in Pivot Table Ms Excel 2013, 2016 and Excel 360 ( Download)
- Excel Magic Trick 1319: Distinct/Unique Count with 1 Condition Using 2 PivotTables. ( Download)
- Enable Distinct Count for Pivot Tables ( Download)
- Get Distinct Count (Ignore Duplicates) in Pivot Table - Excel #Shorts ( Download)
- How to Count Unique Values (Distinct Count) in a Pivot Table in Excel Online and Excel for Mac ( Download)
- How to count unique values Excel ( Download)
