HELP !!

  • Thread starter Thread starter David Taplin
  • Start date Start date
D

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
 
=SUM(1/COUNTIF(A1:A7,A1:A7))

This formula must be array entered - You must press ctrl+shift+enter (as
opposed to just hitting enter) after inserting the formula and subsequently
every time you edit the formula for it to work. If you do this correctly,
Excel will display the formula enclosed in curly braces {}.
 
Back
Top