Excel Query

[WrathOfAchilles]

Hi All,

I have had a quick google about and seen what look like some solutions online but i cant get the basic ones to work and the complex ones were well, complex!

What i want to do is count the distinct number of values in a column. So, i have the total count using this:

=COUNTA(data!A:A)

but i want a secondary count only showing the distinct number of codes in column A on the data sheet. IE

1234
1234
1111
1555

would be a count of 3.


Thanks in advance!

Achilles.

 

[WrathOfAchilles]

OR...

Just tell me is there are dups in the list. searches suggest im close with this:

=IF(MAX(COUNTIF(A:A,A:A))>1,"Duplicates","No Duplicates")

But its doesnt work, always says "No Duplicates"

 

[Hamish]

This will help http://office.microsoft.com/en-au/e...nique-values-in-a-data-range-HP003056118.aspx