D
Duplicate entries
How do I search for duplicate entries in an excel list?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
Chip Pearson has tons of ways of working with duplicates at:
http://www.cpearson.com/excel/duplicat.htm
http://www.cpearson.com/excel/duplicat.htm
D
Duplicate entries
Thanks Dave but this URL doesn't work. Any other suggestions?
P
Peo Sjoblom
Probably down temporary, you can use something like this
=IF(COUNTIF($A$2:A2,A2)>1,"Duplicate","")
where your list starts in A2, copy down in an adjacent column and it will
tag from the second instance of a duplicate, if you want from the first
instance
=IF(COUNTIF($A$2:$A$2000,A2)>1,"Duplicate","")
=IF(COUNTIF($A$2:A2,A2)>1,"Duplicate","")
where your list starts in A2, copy down in an adjacent column and it will
tag from the second instance of a duplicate, if you want from the first
instance
=IF(COUNTIF($A$2:$A$2000,A2)>1,"Duplicate","")
D
Duplicate entries
That worked great thanks.
Peo Sjoblom said:Probably down temporary, you can use something like this
=IF(COUNTIF($A$2:A2,A2)>1,"Duplicate","")
where your list starts in A2, copy down in an adjacent column and it will
tag from the second instance of a duplicate, if you want from the first
instance
=IF(COUNTIF($A$2:$A$2000,A2)>1,"Duplicate","")
D
Dave Peterson
Even though you got a nice answer from Peo, you may want to visit Chip's site.
(It is ok this morning.)
There's lots of neat ideas there.
(It is ok this morning.)
There's lots of neat ideas there.
Duplicate said:That worked great thanks.