Step 1: Select the data range for this entire tabular data that spreads across A1 to D13.
Let us consider the data shown in the above screenshot only, which is spread across A1:D13. This technique of getting unique values in the pivot table is applicable for Excel’s 2013 or later version. Just follow the steps below:īefore we proceed further, let me clear a thing for you. In this article, we will make you walk through the method using which we can count the unique values in the Pivot Table. We need to make some amendments under the pivot table to get the unique count. You could see that the count for countries we traded is 12 in the pivot table, which is definitely not a unique count. However, if we do a pivot table and count the Destination Country, then the results are somewhat weird, as shown in the screenshot below:
If we go through the data, we can say that there are three unique country values: India, United Arab Emirates, and the USA. You can download this Pivot Table Count Unique Excel Template here – Pivot Table Count Unique Excel Template
