| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting rows containing zeros
I am importing a variable amount (10,000+) rows of source data into an Excel
2002 worksheet. Many of the rows will contain zero in column B (total quantity) or zero in column C (total cost) which are not required. How can I automatically delete rows that contain zeros in BOTH columns? The intention is then to rank the remaining data. Thanks in anticipation. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting rows (with zeros) with a macro | Excel Worksheet Functions | |||
| Deleting rows (with zeros) with a macro | Excel Worksheet Functions | |||
| Macro for deleting rows and serialising the remaing rows | Links and Linking in Excel | |||
| How to prevent Excel from deleting leading zeros? | Excel Discussion (Misc queries) | |||
| Deleting Lead Zeros | Excel Worksheet Functions | |||
![Grey Old Man[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
