A unique count (also called a distinct count) represents the number of unique values in a column. In the following list, a "standard" count returns 4 and a distinct/unique count returns 2.

123
456
123
123

In Excel, Pivot Tables can display both a standard count and a distinct count.

If you store the Pivot Table source data in the Data Model instead of the worksheet grid, creating a distinct count is simple. However, neither the Mac version of Excel nor the online version supports creating Pivot Tables from Data Model-based data.

In this video I show you how to create a distinct count in a Pivot Table created in Excel Online or Excel for Mac

For full details see the timestamps below:

⏱ Timestamps
00:00 Introduction
00:00:22 What is a Distinct / Unique Count?
00:01:26 The Formula to Solve the Problem
00:02:43 Create the Pivot Table

🗒 Notes and Resources
Download a copy of the files used in this video: share.getcloudapp.com/kpu8WZN8

✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at theexceltrainer.co.uk

🙋‍♂️ Let's connect on social
Twitter: twitter.com/theexceltrainer
Facebook: facebook.com/theexceltrainer
LinkedIn: linkedin.com/in/thomasmik

#excel #distinctcount #uniquecount

• How to Count Unique Values (Distinct Count) in a Pivot Table in Excel Online and Excel for Mac ( Download)
• Excel Distinct Count with a PivotTable ( Download)
• How to count unique values Excel ( Download)
• Excel PivotTable: Count Unique Records | Distinct Count in Excel PivotTable ( Download)
• Count Unique Values in PivotTables in Excel ( Download)
• How To Count Unique Items In Pivot Table In Excel ( Download)
• Get Distinct Count (Ignore Duplicates) in Pivot Table - Excel #Shorts ( Download)
• Count Unique (Distinct Count) with Excel Pivot Tables ( Download)
• Filter for Unique Values in Excel Mac ( Download)
• 11.1. Distinct count | Excel pivot tables COURSE ( Download)
• Counting in Excel Part7 - Counting unique values using pivot table ( Download)
• How to Count Distinct Values In Excel #excel ( Download)
• How to count unique number of Values in Microsoft Excel | #3 ( Download)
• MS-EXCEL-61-Distinct Count in Pivot Table | Count Unique Value in Pivot Table | Data Model | Excel ( Download)
• Pivot Table Count Unique Values Excel 2010 - 2022 ( Download)