count unique values excel code example
Example 1: excel count unique dates
=COUNT(UNIQUE(B5:B14))
Example 2: count unique values excel
=SUMPRODUCT(1/COUNTIF(data,data))
=COUNT(UNIQUE(B5:B14))
=SUMPRODUCT(1/COUNTIF(data,data))