|
Duplicate entries in an excel list?
How do I search for duplicate entries in an excel list?
|
Chip Pearson has tons of ways of working with duplicates at:
http://www.cpearson.com/excel/duplicat.htm Duplicate entries wrote: How do I search for duplicate entries in an excel list? -- Dave Peterson |
Thanks Dave but this URL doesn't work. Any other suggestions?
"Dave Peterson" wrote: Chip Pearson has tons of ways of working with duplicates at: http://www.cpearson.com/excel/duplicat.htm Duplicate entries wrote: How do I search for duplicate entries in an excel list? -- Dave Peterson |
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","") -- Regards, Peo Sjoblom "Duplicate entries" wrote in message ... Thanks Dave but this URL doesn't work. Any other suggestions? "Dave Peterson" wrote: Chip Pearson has tons of ways of working with duplicates at: http://www.cpearson.com/excel/duplicat.htm Duplicate entries wrote: How do I search for duplicate entries in an excel list? -- Dave Peterson |
That worked great thanks.
"Peo Sjoblom" wrote: 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","") -- Regards, Peo Sjoblom "Duplicate entries" wrote in message ... Thanks Dave but this URL doesn't work. Any other suggestions? "Dave Peterson" wrote: Chip Pearson has tons of ways of working with duplicates at: http://www.cpearson.com/excel/duplicat.htm Duplicate entries wrote: How do I search for duplicate entries in an excel list? -- 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. Duplicate entries wrote: That worked great thanks. "Peo Sjoblom" wrote: 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","") -- Regards, Peo Sjoblom "Duplicate entries" wrote in message ... Thanks Dave but this URL doesn't work. Any other suggestions? "Dave Peterson" wrote: Chip Pearson has tons of ways of working with duplicates at: http://www.cpearson.com/excel/duplicat.htm Duplicate entries wrote: How do I search for duplicate entries in an excel list? -- Dave Peterson -- Dave Peterson |
| All times are GMT +1. The time now is 05:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com