Thread: HELP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Taplin David Taplin is offline
external usenet poster
 
Posts: 4
Default HELP

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