'If there are no blank cells
=SUMPRODUCT(1/COUNTIF(A1:A20,A1:A20))

'and if there are blanks in the range
=SUMPRODUCT((A1:A20<"")/COUNTIF(A1:A20,A1:A20&""))

If this post helps click Yes
---------------
Jacob Skaria


"Elton Law" wrote:

Hi Expert,
Wanna count a column but there may be some duplication.
Want to count the number of persons.
If all count, should be 11.
But want to count without duplication, can it be made? In this case, should
be 7.
(Janie, Jenny are duplicated)


Say Column A ...
Janie
Jenny
Alan
Patrick
Elton
Janie
Janie
Jenny
Alan
Elmer
Tinny