You can't use entire columns as references with either of these formulas:
(in versions of Excel prior to Excel 2007)

If there will never be any empty/blank cells within the range:

=SUMPRODUCT(1/COUNTIF(D1:D4,D1:D4))

If there might be empty/blank cells within the range:

=SUMPRODUCT((D1:D4<"")/COUNTIF(D1:D4,D1:D4&""))

Biff

"bobby769" wrote in message
...
I have a file with multiple worksheets. I need to find the # of unique
values
in D:D. The values in D:D are alpha numeric

Ex.
Values
1a
1d
2e
1a

That should return the # "3" in the destination cell.

Thanks in advance.