How to Count Unique Values (Distinct Count) in a Pivot Table in Excel Online and Excel for Mac
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: https://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 https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #distinctcount #uniquecount