You can read more about it here( or get VBA code): https://www.excelhow.net/count-unique...
This Excel video tutorial, we'll explore two methods to count unique values using a Pivot Table. We'll start by utilizing a help column combined with a formula approach, followed by leveraging the distinct count feature.
Time Stamps
00:00:15 Method 1: Count Unique Values Using Pivot Table using Help Column and Formula
00:02:10 Method 2: Count Unique Values Using Pivot Table Distinct Count Feature
#########
Learn Microsoft Excel Online Free: https://excelhow.net/
#########