How to Count Distinct Value Using Pivot Table
Follow the steps to Count Distinct values using the Pivot table:
Step 1: Create a Pivot Table of the Data
You first need to create a pivot table of Data in which you need to count the Distinct values.
Step 2: Add your item like Customer name into Rows by dragging
Step 3: Now as you can see the Row labels with the Distinct values in the column, Select the range of data of which you want the Count of Distinct values.
Step 4: Preview Count of Distinct Values
How to Count Unique Values in Excel? 5 Easy Ways
Count Unique values in Excel is a feature that can help you to find the values that occur only once in the huge list of Excel. We often need to report the Unique number of customers purchased, the number of products in our stock, List of regions our business covered.
In this article, we explain how to count unique values in an Excel column.
Before moving ahead you should know the difference between unique values and distinct values.
- Unique Values: These are the values that occur only once. Unique Values from the list {1,2,3,1,4,2,7,5,7} are {3,4,5}.
- Distinct Values: These are the Values that are different. Distinct values from the list are {1,2,3,1,4,2,7,5,7} are {1,2,3,4,5,7}.
Contact Us