Count Function

[Matt]

Does anyone know of a function that will count how may
unique items exist in a list?

For example, suppose the following list:

A
B
A
C
D
D

I would want the formula to return an answer of 4, since
this is the number of unique items (A, B, C & D) and so
not to count the multiples of some items.

Any ideas?

Many thanks in advance.

 

[Norman Harker]

Hi Matt!

See:
Chip Pearson:
http://www.cpearson.com/excel/duplicat.htm#CountingUnique

Various formulas for counting unique entries

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Andy B]

Hi

Have a look here:
http://www.cpearson.com/excel/duplicat.htm#CountingUnique

Andy.

 

[mzehr]

Hi Matt
Have a look at Chip Pearson's website:
http://www.cpearson.com/excel/duplicat.htm#CountingUnique
HTH

 

[Dave Ramage]

Picked this up in this group some time ago..

=SUM(IF(FREQUENCY(IF(LEN(A1:A100)>0,MATCH
(A1:A100,A1:A100,0),""), IF(LEN(A1:A100)>0,MATCH
(A1:A100,A1:A100,0),""))>0,1))

This is an array formula, so do Shift+Ctrl+Enter

Cheers,
Dave

 

[Matt]

Thanks to all!

-----Original Message-----
Hi Matt!

See:
Chip Pearson:
http://www.cpearson.com/excel/duplicat.htm#CountingUnique

Various formulas for counting unique entries

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.



.

 

[Frank Kabel]

Hi
try
=SUMPRODUCT((A1:A30<>"")/COUNTIF(A1:A30,A1:A30&""))