| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare two spreadsheets and eliminate duplicates
I would imagine this is in here somewhere, but I haven't found it, and can't
get it to work on my own. I have two spreadsheets that I've put in the same workbook. I want to be able to eliminate the duplicates from the first spreadsheet and make the output into a separate worksheet in the same workbook. The data I'm comparing are in column B on the first worksheet and can go to several thousand rows, and column A on the second that can go to maybe 20,000 rows or so. I really appreciate your help. I could do it in Access, but if a simple VBA solution is available this would be faster since I'd need to put it back into Excel anyway. Thanks again. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/201004/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| eliminate duplicates on a sheet | Excel Worksheet Functions | |||
| How to eliminate everything but duplicates | Excel Worksheet Functions | |||
| Eliminate Duplicates | Excel Programming | |||
| Eliminate duplicates in mailing list | Excel Discussion (Misc queries) | |||
| Eliminate Duplicates in Pivot Table | Excel Discussion (Misc queries) | |||
Threaded Mode
