| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Deletion of rows where a value is satisfied
I have a spreadsheet with 3 colums. Columns are headed Part Number,
Description and Qty. What I would like to do is delete all rows where the qty value is zero. I can't do this using auto filter as I have some small sub headings within the list and want them to stay visible. Any ideas please? Many thanks. Larry. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert rows based on specific value | Excel Worksheet Functions | |||
| flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
| Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) | |||
| Adding Rows to Master Sheet | New Users to Excel | |||
| Copying Rows when hiding other rows | Excel Worksheet Functions | |||
Threaded Mode
