| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Identifying cells without certain text strings
Hello,
I have a list of codes in column B4:B263 as follows: 07129 B4 DT 07129 B4 07129 B4 TH 07555 A1 06999 A1 DT etc. I'd like to set up a list in column C that only includes the rows in column B without the text "DT" or "TH", i.e. C4, C6 and C8 would be empty. Any suggestions would be appreciated. Thanks, Jay |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Cells That Don't Contain the Following Text Strings | Excel Discussion (Misc queries) | |||
| Identifying cells with similar text | Excel Discussion (Misc queries) | |||
| Searching for mulitple strings and assigning identifying number | Excel Worksheet Functions | |||
| Comparing text strings in cells | Excel Discussion (Misc queries) | |||
| Comparing text strings in cells | Excel Discussion (Misc queries) | |||
Threaded Mode
