With data in A1 to A100, try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Carla" wrote in message
...
I have a large file which I have downloaded from our company database. I
want to be able to count only the unique values in a specific column.
Right
now there are blank cells and duplicate values. How do I do this?