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))
Hindi-Tech :Count unique values in a range in excel with COUNTIF and SUM...
0
![B R YADAV]()
May 27, 2021
May 27, 2021
Tags
