| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
deleting rows in large database (+20k rows)
i need to delete all rows whose account numbers do not match a set of 20-30
account numbers. since the database is quite large was planning to use Union application to create range of rows to be deleted. what is easiest method to distinguish between rows containing the 20-30 account numbers i want to save and the hundreds which need to be deleted? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Very large database (600k rows, 40 columns in xlsx) | Excel Discussion (Misc queries) | |||
| Macro for deleting rows and serialising the remaing rows | Links and Linking in Excel | |||
| large database with multiple rows | Excel Worksheet Functions | |||
| How do i insert of spacer rows between rows in large spreadsheets | Excel Discussion (Misc queries) | |||
| Help!!! I have problem deleting 2500 rows of filtered rows | Excel Programming | |||
Threaded Mode
