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.
>.
