What are distinct and unique values in Excel?

Answer 1

Distinct values are the set of values in a column with no duplications. Unique values are those values that occur only once.

If you had a set of values {2, 27, 18, 27, 39, 10, 2}

The distinct values are {2, 10, 18, 27, 39}

The unique values are {10, 18, 39}