Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 | |||
rows identification and deletion | Excel Discussion (Misc queries) | |||
Automatic Deletion of Rows | New Users to Excel | |||
On deletion of rows | Excel Discussion (Misc queries) | |||
Deletion of rows where a value is satisfied | Excel Worksheet Functions | |||
Deletion of rows according to background color | Excel Programming |