Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I merge 2 data bases in Excel avoiding duplicate records?
Have two files of records. Want to merge but avoid ending up with two of the
same records in the combined database. Is there way to do this without alphabetizing and visually scanning for duplicates? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I merge 2 data bases in Excel avoiding duplicate records?
You might want to try allowing duplicate records to be imported and then removing the duplicates. An easy way to do this is using the Data-Advanced filter setting an empty criteria range and setting the unique records flag to true. -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=566147 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel data source will not merge changes to Word | Excel Discussion (Misc queries) | |||
Excel rounds up, then in mail merge uses nonrounded data | Excel Discussion (Misc queries) | |||
Link excel and word in mail merge without losing your data source? | Excel Discussion (Misc queries) | |||
how can i locate duplicate data in an excel data table? | Excel Worksheet Functions | |||
How to delete duplicate records when I merge two lists (deleting . | Excel Worksheet Functions |