| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove rows where value = 0
H
I have 690 rows of information with one of the columns called "Feb 03". I would like all rows where the value in Feb 03 is "0" removed and the rows below to move up. There will be approx 250 rows removed. I could do this manually but I will need to be able to do this for future worksheets so a formula to speed up the process would be much appreciated Thanks in advanc Malcolm Davidson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove last n rows | Excel Worksheet Functions | |||
| remove rows in one sheet from similar rows in another | Excel Worksheet Functions | |||
| How do I remove empty Rows | Excel Discussion (Misc queries) | |||
| How to remove a lot of rows? Please help | Excel Discussion (Misc queries) | |||
| How to remove rows for printing | Excel Discussion (Misc queries) | |||
Threaded Mode
