HELP

[David Taplin]

I have a long long column of company names ie

Company a
Company b
Company c

But some of them are duplicated ie

Company a
Company b
Company b
Company b
Company c
Company c
Company c

How can I do a count on these companies so that I'm only provided with a
count of each individual company name. (rather than the duplicates as well).

So the count for the list of duplicates above would be '3'.

Any one help????

Regards

Dave

 

[Tom Ogilvy]

=SUMPRODUCT(1/COUNTIF(A1:A7,A1:A7))

if there are no blank cells in A1:A7

 

[David Taplin]

IT WORKS, Thanks tome, you've just saved my bacon !!

Much appreciated

Dave

 

[Ron Rosenfeld]

I have a long long column of company names ie

Company a
Company b
Company c

But some of them are duplicated ie

Company a
Company b
Company b
Company b
Company c
Company c
Company c

How can I do a count on these companies so that I'm only provided with a
count of each individual company name. (rather than the duplicates as well).

So the count for the list of duplicates above would be '3'.

Any one help????

Regards

Dave

You can also download and install the addin morefunc.xla.

One of the functions is =COUNTDIFF(array, blanks) and you can specify whether
or not to include blanks.

morefunc is available from:

http://perso.wanadoo.fr/longre/excel/pages/Downloads.htm#Morefunc.xll


--ron