Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete duplicate and original entries in excel
I'm working with a large excel database and need to delete not only
the duplicate record, but also the original one-- if that makes sense. I've merged two databases together--one that's a master list of names and contact info and the second with names of people who have already been contacted. So when I put the two together, for instance a record for Joe Smith shows up twice because he's been contacted, so I need to delete both entries, so he's effectively no longer in the database...any suggestions? Everything that I've seen only deletes the dulplicate, which would mean Joe Smith would still show up in the database. Thanks for your help!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete duplicate and original entries in excel
If I were you I would use microsoft access - queries do all that for you..
Good luck! Sara " wrote: I'm working with a large excel database and need to delete not only the duplicate record, but also the original one-- if that makes sense. I've merged two databases together--one that's a master list of names and contact info and the second with names of people who have already been contacted. So when I put the two together, for instance a record for Joe Smith shows up twice because he's been contacted, so I need to delete both entries, so he's effectively no longer in the database...any suggestions? Everything that I've seen only deletes the dulplicate, which would mean Joe Smith would still show up in the database. Thanks for your help!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete duplicate and original entries in excel
If these have all been added into a single sheet and names are all in same
column, you can add a formula to an unused cell on the row and extend it down the entire list. Assume names are in column A and go from row 2 to row 1500. Put a formula like this in an unused column on row 2 and fill down: =CountIf(A$2:A$1500,A2) The set up Data | Filter | AutoFilter Pick the pulldown at the top of the column with your formulas in it and choose (Custom) from the drop-down list. In the dialog that appears choose the 'is greater than' option and enter 1 as the value. Now only entries that appear more than once in the list will be displayed, you can safely selecte them all and Edit | Delete to delete the entire group of rows. Remove the AutoFilter and you'll see all of the other entries left over. Practice on a COPY of your database file. " wrote: I'm working with a large excel database and need to delete not only the duplicate record, but also the original one-- if that makes sense. I've merged two databases together--one that's a master list of names and contact info and the second with names of people who have already been contacted. So when I put the two together, for instance a record for Joe Smith shows up twice because he's been contacted, so I need to delete both entries, so he's effectively no longer in the database...any suggestions? Everything that I've seen only deletes the dulplicate, which would mean Joe Smith would still show up in the database. Thanks for your help!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete duplicate and original entries in excel
Hi,
Refer to "Filter by using advanced criteria" in the Microdoft on-line help Challa Prabhu " wrote: I'm working with a large excel database and need to delete not only the duplicate record, but also the original one-- if that makes sense. I've merged two databases together--one that's a master list of names and contact info and the second with names of people who have already been contacted. So when I put the two together, for instance a record for Joe Smith shows up twice because he's been contacted, so I need to delete both entries, so he's effectively no longer in the database...any suggestions? Everything that I've seen only deletes the dulplicate, which would mean Joe Smith would still show up in the database. Thanks for your help!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
search/delete duplicate entries in excel '02? | Excel Worksheet Functions | |||
How do I delete duplicate entries in excel? | New Users to Excel | |||
find duplicate entries and delete them? | Excel Worksheet Functions | |||
How do I delete duplicate entries? | Excel Worksheet Functions | |||
Add numbers for duplicate entries then delete | Excel Worksheet Functions |