Excel Course : The Ultimate Excel Programmer Course
This tutorial explains how to count unique values based on multiple columns in Excel.
The combination 1 and Jhonson appears 2 times so the unique value would be equal to (1/2) + (1/2) = 1
How Formula Works
COUNTIFS counts the number of times the values appear based on multiple criteria.
|COUNTIFS Formula Evaluation|
Then all the values are divided by 1 and SUMPRODUCT sums all the fraction values.
Count Unique Values (More than 2 columns)
1. 3 Ways to extract unique values
2. Count Unique values in a column
3. Select and Count Duplicate values in Excel