Hindi-Tech :Count unique values in a range in excel with COUNTIF and SUM...

Hindi-Tech :Count unique values in a range in excel with COUNTIF and SUMPRODUCT

Using SumProduct and CountIF Formula:

=SUMPRODUCT(1/COUNTIF(data,data))

=SUMPRODUCT(1/COUNTIF(A1:A10,A1:A10))