=SUM(1/COUNTIF(A1:A1000,A1:A1000))
(Array Entered - CTRL+SHIFT+ENTER)

or

=SUM(N(FREQUENCY(A1:A1000,A1:A1000)0))
(Array Entered - CTRL+SHIFT+ENTER)
(Numbers only in a mix of numbers & Text)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



"ibeetb" wrote in message ...
I need to count the unique (non-duplicate) values in a column range.
Does anybody know an Excel or VBA function to do this?