| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I combine two Excel Workbooks and delete the duplicate colu
I am dealing with 2 Workbooks that have about 40,000 rows each, so it is way
too much work to combine, and edit them by hand. I have numbers in the 1st column, 2nd i have Text, and 3rd I have Numbers. One File only has the first 2 columns. I need my other file to be combined w/ this one. The other file has all 3 columns, but a lot of numbers in the 1st column should match each other. So i want them to combine, but have no duplicate numbers. Can anyone help me? thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I combine five EXCEL 2003 workbooks into one? | Excel Discussion (Misc queries) | |||
| How do I combine five Excel 2003 workbooks? | Excel Worksheet Functions | |||
| How do you delete duplicate addresses, but keep duplicate names? | Excel Discussion (Misc queries) | |||
| How to combine Excel 2002 files and remove duplicate records? | New Users to Excel | |||
| How do I delete duplicate entries in excel? | New Users to Excel | |||
Threaded Mode
