How to Count Duplicate Values Only Once In any Column in Excel in few seconds?

Sometimes we have some duplicate values  in a column of our worksheet, and we need to count the same or duplicate values only once which means.

To Calculate duplicate values only once watch the video below for step by step guidance:

There are two Methods to complete this task;

1-         By Implementing Excel Formula

2-         By Using KU Tools

Here I am going to mention only first method.

To count duplicate values only once you need to add following formula.

=SUMPRODUCT((C5:C20<>"")/COUNTIF(C5:C20,C5:C20&""))

into a blank cell where you want to output the result, and press Enter key to get the result, see Picture [1] below:

      Note    : 

In the above formula, C5:C20 is the data range that you want to count the duplicates only once.