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  
 
 [ 3 post ] 

 Relevant Pages 

1. How do you use the COUNT function to count cells that are non number

2. count and duplicate text cells in the same column into one cell

3. Counting Non Duplicated

4. Non-Duplicate Count in a Pivot Table?

5. Copying non-active cell to another non-active cell

6. Excel duplicate help – find count remov e duplicate rows (aka dedupe duplicates)

7. Excel duplicate help – find count remov e duplicate rows (aka dedupe duplicates)

8. count non- blank cells

9. Basic Question: To count the number of non-empty cells in a column

10. Counting Non Blank Cells?


 
Powered by phpBB® Forum Software © phpBB Group