Counting Unique Values

carl · May 27, 2004

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 · May 27, 2004

Here's one way of doing it:

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

HTH
Jason
Atlanta, GA

Frank Kabel · May 27, 2004

Hi
use the following formula
=SUMPRODUCT((D1

100<>"")/COUNTIF(D1

100,D1

100&""))
if D1

100 is your range with data