To count the number of unique or distinct values in a list in Microsoft Excel, use the following formula. A2:A177 is the range of cells you want to count the unique values in:
=SUM(IF(FREQUENCY(A2:A177,A2:A177)>0,1))
To count the number of unique or distinct values in a list in Microsoft Excel, use the following formula. A2:A177 is the range of cells you want to count the unique values in:
=SUM(IF(FREQUENCY(A2:A177,A2:A177)>0,1))