How To Count Unique Values In Excel Using Formula

Sometimes you may want to count unique values exist in a range that contains duplicate values. You can count the number of unique values by using a filter, but in this article we use Excel formula to solve it. Count the unique values (not contain blank cells) =SUMPRODUCT(1/COUNTIF(range,range)) or {=SUM(1/COUNTIF(range,range))}…