| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare and Filter Out Large Database
I have a large online excel wholesale price catalog - 45,000+ line items down
and about 30 columns across. All items have a unique part number. From that database, I need to filter out about 4,000 items from a separate excel spreadsheet (a subset of the larger database) so as not to duplicate the items. How do I lookup and delete those 4K items from the larger spreadsheet without disrupting the data from the other columns? Someone told me to consider using V-Lookup. Any thoughts? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Large Database Problem-linking worksheets and printing | Excel Discussion (Misc queries) | |||
| compare small and large figures in one chart | Charts and Charting in Excel | |||
| searching a large database with a long list of search terms | Excel Discussion (Misc queries) | |||
| Navigating a large database? | Excel Discussion (Misc queries) | |||
| Pulling data out of a large database | Excel Discussion (Misc queries) | |||
Linear Mode
