| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete rows with common element
The text to be used as the "trigger" is located in Column B for each record.
If the key text phrase is located in this cell I would like the entire record (row) to be deleted. I have tried the advanced filter but it requires all the each record to be identical. Thank-you "Don Guillett" wrote: yes. More info. where in the row? Only the word in the cell or holiday sss in the same cell? -- Don Guillett SalesAid Software "Anauna" wrote in message ... Hello, Is there a way to delete all rows that contain a common text element (i.e. "Holiday"). The remaining information in the records may differ from every other row.-- Thank-you and all suggestions are appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ADDING COLUMNS FOR COMMON ROWS | Excel Discussion (Misc queries) | |||
| Sum Value of rows based on two common fields | Excel Worksheet Functions | |||
| Comparing two different sets of data with common element | Excel Worksheet Functions | |||
| Common Spacing of Rows | Excel Worksheet Functions | |||
| Deleting rows containing common data | Excel Discussion (Misc queries) | |||
Threaded Mode
