You sure you don't have a repeat of one of those numbers?

Returns 10 for me with 1 through 10 in A1:A10


Gord Dibben MS Excel MVP

On Wed, 4 Nov 2009 12:38:01 -0800, Carla
wrote:

I tried that formula with a column showing numbers 1-10 with your formula,
and it said I only have 9 different items when it should be 10.

Now, when I did it with words, it worked correctly.

Thank you,
Carla

"Mike H" wrote:

Hi,

Try this

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

Mike

"Carla" wrote:

I want to count how many different customers are in a column. I have a lot
of duplicate customers, so I need a formula that will tell me how many
different ones there are. In my example below the total count is 4 in a
total of 5 lines.

I.E.
adva
palm
palm
john
teak