Google Sheets: Pivot Table Countunique To Count Each Unique Item Once

2020 1:23
Synopsis
Use the COUNTUNIQUE summary value to count only one instance. For example, for {Bob, Bob, Mary, Andrew} COUNTA = 4, but ...

You Might Also Like

Excel Pivot Table: How to Count Unique Values 1:22
Excel Pivot Table: How To Count Unique Values
2025
Create unique items list & count duplicates using Pivot Tables 1:14
Create Unique Items List & Count Duplicates Using Pivot Tabl...
2024
Count Unique (Distinct) Items in Excel Pivot Table 1:31
Count Unique (distinct) Items In Excel Pivot Table
2025
Download Options
Choose a download method below. All links open in new tabs.
Service Features Action
Ssvid
MP4 & MP3 • HD Quality • Browser Extension Available
Download
SaveFrom
MP4 & MP3 • HD Quality • Browser Extension Available
Download
Security Notice: These are third-party services. We recommend using antivirus software and being cautious of pop-up ads.