Count unique values!!

[albertc30]

Hi all.

After about 30 minutes googling away I have given up.

I am trying to count unique values which usually is quite straight forward but now I am getting #DIV/0! error.

I am using the formula "=SUMPRODUCT(1/COUNTIF(D5:D250,D5:D250))" and have used others to no sucess.

Column D has a dropdown list with validation. Could this be why it's not working?

As always, many thanks for all the help and be safe.
Albert

 

[albertc30]

Ops...

Finally I found one...

=SUMPRODUCT((A2:A100 <> "")/COUNTIF(A2:A100,A2:A100 & ""))

Typical!

Sorry everyone. But as always, much appreciated for all the help.

Be safe.