Excel – Distinct Count in a Pivot Table – Mac & Online

A unique count (also called a distinct count) represents the number of unique values in a column. In the following list, a “standard” count is 4 and a distinct/unique count is 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. Links to the video and individual sections below:

Introduction

What is a Distinct / Unique Count?

The Formula to Solve the Problem

Create the Pivot Table