Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP
=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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
HELP
On Tue, 19 Aug 2003 14:49:08 +0100, "David Taplin" wrote:
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...m#Morefunc.xll --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|