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.