Finding duplicates in a column

F

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
 
V

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
 
F

fergusor

via135 said:
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
Click to expand...
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
 
P

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
 
R

Ron P

fergusor said:
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?
Click to expand...

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 : )
 
V

via135

yes..Ron!

i haven't noticed the mistake until your post!

thanks for correcting!

-via13
 
P

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
 
Top