| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel -find records which DO NOT contain a particular text string
I am trying to find all records which DO NOT contain a particular text
string. Can someone help me with some ideas. THanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel -find records which DO NOT contain a particular text string
Data Filter AutoFilter Custom DoesNotContain yourparticuartext
Vaya con Dios, Chuck, CABGx3 "JackBuff" wrote: I am trying to find all records which DO NOT contain a particular text string. Can someone help me with some ideas. THanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel -find records which DO NOT contain a particular text str
Thanks, Chuck.
This worked like a champ. Sometimes the obvious, isn't so obvious. JackBuff "CLR" wrote: Data Filter AutoFilter Custom DoesNotContain yourparticuartext Vaya con Dios, Chuck, CABGx3 "JackBuff" wrote: I am trying to find all records which DO NOT contain a particular text string. Can someone help me with some ideas. THanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel -find records which DO NOT contain a particular text string
One way would be to have a helper column-
=IF(ISNUMBER(SEARCH("YYY",A1)),1,0) which will return 1 if the cell has the text YYY and 0(zero) if not Regards. Bill Ridgeway Computer Solutions "JackBuff" wrote in message ... I am trying to find all records which DO NOT contain a particular text string. Can someone help me with some ideas. THanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel -find records which DO NOT contain a particular text str
You're welcome Jack.......thanks for the feedback.
It all depends on which direction one is looking in when asked, "How's the view" g Vaya con Dios, Chuck, CABGx3 "JackBuff" wrote: Thanks, Chuck. This worked like a champ. Sometimes the obvious, isn't so obvious. JackBuff "CLR" wrote: Data Filter AutoFilter Custom DoesNotContain yourparticuartext Vaya con Dios, Chuck, CABGx3 "JackBuff" wrote: I am trying to find all records which DO NOT contain a particular text string. Can someone help me with some ideas. THanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel -find records which DO NOT contain a particular text str
Thanks, Bill. I'll give this one a try also. It's good to have
alternatives. JackBuff "Bill Ridgeway" wrote: One way would be to have a helper column- =IF(ISNUMBER(SEARCH("YYY",A1)),1,0) which will return 1 if the cell has the text YYY and 0(zero) if not Regards. Bill Ridgeway Computer Solutions "JackBuff" wrote in message ... I am trying to find all records which DO NOT contain a particular text string. Can someone help me with some ideas. THanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import Text file into Excel and match up records | Excel Discussion (Misc queries) | |||
| Find duplicate records in Excel 2003 | Excel Discussion (Misc queries) | |||
| How do I search a text string in many excel worksheets (files)? | Excel Worksheet Functions | |||
| Looking up a string of text within a string of text | Excel Worksheet Functions | |||
| Excel - counting cells containing a text string | Excel Worksheet Functions | |||
Linear Mode
