Counting Unique Values

[carl]

Is there a way to count the number of "unique" values in
column D below ?

A B C D
6 Cancel Time Units Check Robinson
7 05/24/04 10 Good Stevens
8 05/24/04 10 Robinson
9 05/24/04 20 Good Caster

Thank you in advance.

 

[Jason Morin]

Here's one way of doing it:

http://j-walk.com/ss/excel/usertips/tip061.htm

HTH
Jason
Atlanta, GA

 

[Frank Kabel]

Hi
use the following formula
=SUMPRODUCT((D1100<>"")/COUNTIF(D1100,D1100&""))
if D1100 is your range with data