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

Much appreciated

Dave

"Tom Ogilvy" wrote in message
...
=SUMPRODUCT(1/COUNTIF(A1:A7,A1:A7))

if there are no blank cells in A1:A7

--
Regards,
Tom Ogilvy


"David Taplin" wrote in message
...
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