counting non-duplicate cells
Author Message
counting non-duplicate cells

I have a column with customer ID# in it.  I want to count
how many customer ID#s are in the column.  The problem is
some customer ID#s will appear more than once, and will
not always be adjacent to each other, and it's not easy to
clear duplicates, and or just count the number of rows
minus the duplicates.  Does anyone know of a formula for
this?  Thank you.

Sun, 30 Oct 2005 21:16:13 GMT
counting non-duplicate cells
Joshua,

Try this
=COUNTA(A1:A10)-COUNTIF(A1:A10,A1:A10)+1

--
HTH

-------

Bob Phillips
... looking out across Poole Harbour to the Purbecks

Quote:
> I have a column with customer ID# in it.  I want to count
> how many customer ID#s are in the column.  The problem is
> some customer ID#s will appear more than once, and will
> not always be adjacent to each other, and it's not easy to
> clear duplicates, and or just count the number of rows
> minus the duplicates.  Does anyone know of a formula for
> this?  Thank you.

Sun, 30 Oct 2005 21:35:31 GMT
counting non-duplicate cells
Thanks, but I ended up with a number greater then the
total number of cells in my range.  I should have some
number less then the total number of cells in my range
since I'm trying to not count the duplicates in the
range.

Quote:
>-----Original Message-----
>Joshua,

>Try this
>=COUNTA(A1:A10)-COUNTIF(A1:A10,A1:A10)+1

>--
>    HTH

>    -------

>    Bob Phillips
>    ... looking out across Poole Harbour to the Purbecks

>> I have a column with customer ID# in it.  I want to
count
>> how many customer ID#s are in the column.  The problem
is
>> some customer ID#s will appear more than once, and will
>> not always be adjacent to each other, and it's not easy
to
>> clear duplicates, and or just count the number of rows
>> minus the duplicates.  Does anyone know of a formula for
>> this?  Thank you.

>.

Sun, 30 Oct 2005 21:56:31 GMT

 Page 1 of 1 [ 3 post ]

Relevant Pages