Count Unique (Distinct) Items in Excel Pivot Table
HTML-код
- Опубликовано: 21 фев 2024
- Count Unique (Distinct) Items in Excel Pivot Table
How to count unique items (distinct count) in a Microsoft Excel pivot table. For example, if you're analyzing sales data, you might have questions such as:
--How many unique products were sold in each store?
--How many unique salespeople sold each product per region?
This method works in Excel 2013 and later versions.
To get the sample file, and to see other ways to get a pivot table distinct count, go my Contextures website:
www.contextures.com/pivottabl...
Instructor: Debra Dalgleish, Contextures Inc.
More Excel Tips and Tutorials: www.contextures.com/tiptech.html
Subscribe to Contextures RUclips: ruclips.net/user/contextu...
#ContexturesExcelTips
many thanks ! good
You're welcome, and thanks for your comment!