Finding duplicates in a column

[fergusor]

Hi Guys,

I've got alist of 23000 numbers in column A, is there a way I ca
determine whether there are any duplicates (I don't need to know wha
the duplicates are).

Thanks,
Richard

 

[via135]

hi
assuming the data in A1:A23000

enter in

B1: =if(countif($A$1,$A$23000,A1)>1,"duplicate","") and copy the
formula down upto B23000

use autofilter to findout the list of "duplicate"

-via135

 

[fergusor]

hi
assuming the data in A1:A23000

enter in

B1: =if(countif($A$1,$A$23000,A1)>1,"duplicate","") and copy the
formula down upto B23000

use autofilter to findout the list of "duplicate"

-via135

I've tried using this formula and I get an error that states 'Yo
entered too many arguments for this function'.

Can anyone help with this?

The values are in columns A1 to A23000, and the values are like 1001
1002, 1003, 1004...

Thanks,
Richard

 

[Pete_UK]

Change the formula to:

=if(countif($A$1:$A$23000,A1)>1,"duplicate","")

i.e. the comma should be a colon to indicate a range.

Hope this helps.

Pete

 

[Ron P]

I've tried using this formula and I get an error that states 'You
entered too many arguments for this function'.

Can anyone help with this?

The formula has a slight error. It should read
=if(countif($A$1:$A$23000,A1)>1,"duplicate","")
(the first comma in the formula should have been a : )

 

[via135]

yes..Ron!

i haven't noticed the mistake until your post!

thanks for correcting!

-via13

 

[Pete_UK]

I've just realised from this post and another that although postings on
Excelforum show up in Google Groups, the reverse is not the case, so my
earlier posting was invisible to those who use Excelforum.

Should I therefore ignore any postings from Excelforum and not bother
to respond to them?

Any insights?

Pete