| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting rows based on a cell value
Hi,
I need to delete all the rows in a worksheet which match a particular value in a column. Below is a sample of the sheet: Partner# Name Customer# A_NOVATION ABBOTT NOVATION 26967 B_NOVATION BOSTON NOVATION 26967 A_PREMIER ABBOTT PREMIER 26968 B_PREMIER BOSTON PREMIER 26968 A_BROADLAN ABBOTT BROADLANE 26969 B_BROADLAN BOSTON BROADLANE 26969 A_BROADLAN ABBOTT BROADLANE 26971 B_BROADLAN BOSTON BROADLANE 26971 A_BROADLAN ABBOTT BROADLANE 26972 B_BROADLAN BOSTON BROADLANE 26972 A_NOVATION ABBOTT NOVATION 26973 B_NOVATION BOSTON NOVATION 26973 MEDASSETS MEDASSETS HSCA INC 26974 A_NOVATION ABBOTT NOVATION 26975 B_NOVATION BOSTON NOVATION 26975 A_HEALTHTR ABBOTT HEALTHTRUST 26977 B_HEALTHTR BOSTON HEALTHTRUST 26977 So basically i want to delete all the rows for which column 1 has a value starting with A_. Can anyone help me with this? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting Rows based on a Value | Excel Worksheet Functions | |||
| Deleting rows based on values in a a cell in the row | New Users to Excel | |||
| Deleting rows based on a cell value | Excel Worksheet Functions | |||
| Deleting rows based on cell criteria | Excel Programming | |||
| Deleting Rows based on text in cell & formatting cell based on text in column beside it | Excel Programming | |||
Threaded Mode
