| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Rows
I have a data set that looks like this:
LA BEL: M_FRONT _HEIGHT Po ints Taken: 1 Actual Nominal #NAME? #NAME? Dev Out/Tol Y: 1808.608 1808.8 1.5 -1.5 -0.192 ********** LA BEL: M_REAR_ HEIGHT Po ints Taken: 1 Actual Nominal #NAME? #NAME? Dev Out/Tol Y: 1808.3624 1808.8 1.5 -1.5 -0.4376 ********** I want to delete all the rows except those that have Y: in the first column. How would I do that? Everything I have tried so far has only deleted some of the rows, but not all. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro for deleting rows and serialising the remaing rows | Excel Programming | |||
| Macro for deleting rows and serialising the remaing rows | Links and Linking in Excel | |||
| Macro for deleting rows and serialising the remaing rows | Setting up and Configuration of Excel | |||
| Macro for deleting rows and serialising the remaing rows | Excel Worksheet Functions | |||
| Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
![amboo_radley[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
