Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge two spreadsheets with names database then search for duplica
I have two mailing data bases with names; I want to merge them into one
spreadsheet, then check for duplicates. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge two spreadsheets with names database then search for duplica
Copy both databases to one Excel worksheet preferably in the same column(s).
Then the massaging starts. What do you want to do with duplicates if/when found? Keep one of each and delete the extras? Use Advanced filter and check "unique records" and "copy to another place" See Debra Dalgleish's site for more on this. http://www.contextures.on.ca/xladvfilter01.html Tag them so you know which are duplicates and hide them? See Chip Pearson's site for tagging and highlighting duplicates http://www.cpearson.com/excel/duplicat.htm Gord Dibben MS Excel MVP On Thu, 2 Nov 2006 15:09:02 -0800, Molly wrote: I have two mailing data bases with names; I want to merge them into one spreadsheet, then check for duplicates. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Database Search For Help? | Excel Discussion (Misc queries) | |||
searching a large database with a long list of search terms | Excel Discussion (Misc queries) | |||
How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
Creating A Search Database..Need Help | Excel Discussion (Misc queries) | |||
How do I create a "List If" function.I need to search a database . | Excel Worksheet Functions |