Count Question
 

I have a worksheet that has a list of customers on column B. How do I count
how many total customers I have? Some of the customers are on there more than
once so I just want to count the number of customers not including the
duplicates.
This should be simple but I can't seem to figure it out.

Count Question
 

say from B1 thru B100 with no blanks:

=SUM(1/COUNTIF(B1:B100,B1:B100)) entered with CNTRL-SHFT-ENTER
--
Gary''s Student - gsnu200740


"Secret Squirrel" wrote:

I have a worksheet that has a list of customers on column B. How do I count
how many total customers I have? Some of the customers are on there more than
once so I just want to count the number of customers not including the
duplicates.
This should be simple but I can't seem to figure it out.

Count Question
 

Thanks Gary!

"Gary''s Student" wrote:

say from B1 thru B100 with no blanks:

=SUM(1/COUNTIF(B1:B100,B1:B100)) entered with CNTRL-SHFT-ENTER
--
Gary''s Student - gsnu200740


"Secret Squirrel" wrote:

I have a worksheet that has a list of customers on column B. How do I count
how many total customers I have? Some of the customers are on there more than
once so I just want to count the number of customers not including the
duplicates.
This should be simple but I can't seem to figure it out.

Count Question
 

Thank Pearson:

http://www.cpearson.com/excel/Duplicates.aspx


--
Gary''s Student - gsnu200740


"Secret Squirrel" wrote:

Thanks Gary!

"Gary''s Student" wrote:

say from B1 thru B100 with no blanks:

=SUM(1/COUNTIF(B1:B100,B1:B100)) entered with CNTRL-SHFT-ENTER
--
Gary''s Student - gsnu200740


"Secret Squirrel" wrote:

I have a worksheet that has a list of customers on column B. How do I count
how many total customers I have? Some of the customers are on there more than
once so I just want to count the number of customers not including the
duplicates.
This should be simple but I can't seem to figure it out.

Count Question
 

Here's another one that accounts for empty cells (not counted as a unique):

=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))

--
Biff
Microsoft Excel MVP


"Secret Squirrel" wrote in
message ...
I have a worksheet that has a list of customers on column B. How do I count
how many total customers I have? Some of the customers are on there more
than
once so I just want to count the number of customers not including the
duplicates.
This should be simple but I can't seem to figure it out.