excel number of unique values in a column code example Example: count unique values excel =SUMPRODUCT(1/COUNTIF(data,data))