How to count same or duplicate values only once in a column?

Arrange Numbers From Least To Greatest Excel

How to count same or duplicate values only once in a column? Count excel same once only value duplicate values add column handy kutools than doc

How to count same or duplicate values only once in a column?

How to count same or duplicate values only once in a column?
How to count same or duplicate values only once in a column?