Sign up for our Excel webinar, times added weekly: https://www.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:
https://www.excelcampus.com/pivot-tables/distinctcount-pivot-tables.

Related Videos:
Excel Data Analysis Challenge - Count Transactions with Multiple Rows:
https://www.youtube.com/watch?v=_3lX1NwIfzQ
Introduction to Pivot Tables, Charts, and Dashboards in Excel:
https://www.youtube.com/watch?v=9NUjHBNWe9M&t=5s
Refresh Pivot Table Automatically when Source Data Changes:
https://www.youtube.com/watch?v=NI1UQcYtl1A
5 Reasons to Use an Excel Table as the Source of a Pivot Table: https://www.excelcampus.com/tables/table-source-pivot-table/

#MsExcel #ExcelCampus
00:00 Introduction
00:50 Pivot Table Solution
05:33 Power Pivot Solution