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)
- Count Unique Values in PivotTables in Excel ( Download)
- Distinct count in pivot table | how to find unique count in pivot table ( Download)
- Excel Distinct Count with a PivotTable ( Download)
- Excel PivotTable: Count Unique Records | Distinct Count in Excel PivotTable ( Download)
- How To Count Unique Items In Pivot Table In Excel ( Download)
- Get Distinct Count (Ignore Duplicates) in Pivot Table - Excel #Shorts ( Download)
- How to add unique count to a pivot table ( Download)
- Excel Tip: How To Use Distinct or Unique Count In An Excel Pivot Table ( Download)
- How to Count Unique Values (Distinct Count) in a Pivot Table in Excel Online and Excel for Mac ( Download)
- Find Out Unique Data by Using Pivot Table | Use of Distinct Count Function ( Download)
- Enable Distinct Count for Pivot Tables ( Download)
- How to count unique values Excel ( Download)
- Excel Magic Trick 1319: Distinct/Unique Count with 1 Condition Using 2 PivotTables. ( Download)
- Find Unique Count in Pivot Table ( Download)
