| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula/Macro to delete rows that do not meet criteria from a list?
If I have a list of data on one sheet, is there any way I can use a
formula to compare another sheet to that list and delete rows that do not meet the criteria? (example - sheet 2 has a list of activities, so if cell a1 in sheet 1 does not match any of the activities listed in sheet 2 column a, then the row will delete itself) Probably not, but Im just curious. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete Rows based on criteria in excel | Excel Discussion (Misc queries) | |||
| Hide rows that meet certain criteria in an excel template | Excel Worksheet Functions | |||
| Delete data in cells that don't meet criteria | New Users to Excel | |||
| Auto-generating a list of records that meet a pattern criteria | Excel Discussion (Misc queries) | |||
| Deleting Rows Automatically using a Text File List | Excel Discussion (Misc queries) | |||
Threaded Mode
