| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Duplicate entries in an excel list?
How do I search for duplicate entries in an excel list?
|
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a cascading list box using Excel | Excel Discussion (Misc queries) | |||
| How can I purge duplicate entries in Excel | Excel Discussion (Misc queries) | |||
| export excel file to outlook express contact list | New Users to Excel | |||
| Excel 2003: Match one list against another and highlight differenc | Excel Worksheet Functions | |||
| Duplicate records in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
