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

 

[Scott Johnson]

A quick and easy way would be to use the Consolidate Function. Insert
a column next to the company names and then use the Consolidate
function to remove all the duplicate listings and then count the
results.

Good Luck,
Scott