How large is the list?

Try something like this...

=SUMPRODUCT(1/COUNTIF(A1:A100,A1:A100))

Assumes no empty cells within the list.

If the list is 1000's of rows then a better formula can be created.