| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I merge two spreadsheets so it removes the duplicates?
Is there a way to merge to large spreadsheets together so that it will
automatically remove the duplicates so that only one of the same enteries remain? Thank you for your help! |
|
#2
|
|||
|
|||
|
Hi Megan
no "automatic" way that i know of, but you might like to have a read of http://www.cpearson.com/excel/duplicat.htm Chip's got lots of ideas there on dealing with duplicates. Cheers julieD "Megan" wrote in message ... Is there a way to merge to large spreadsheets together so that it will automatically remove the duplicates so that only one of the same enteries remain? Thank you for your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merge Data from Multiple Spreadsheets | Excel Worksheet Functions | |||
| merge 2 spreadsheets | Excel Discussion (Misc queries) | |||
| How do you merge two spreadsheets to update data. | Excel Discussion (Misc queries) | |||
| Can I merge Excel spreadsheets with Quickbooks invoicing? | Excel Discussion (Misc queries) | |||
| Merge two Excel 2000 spreadsheets | Excel Discussion (Misc queries) | |||
Linear Mode
