Tag: Unique
Microsoft Excel: Count the number of unique values in list
by Tom Gee on Apr.19, 2010, under Excel
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))
