Excel -find records which DO NOT contain a particular text string

Excel -find records which DO NOT contain a particular text string

Post by SmFja0J1Zm » Thu, 25 May 2006 00:59:02


I am trying to find all records which DO NOT contain a particular text
string. Can someone help me with some ideas.

THanks
 
 
 

Excel -find records which DO NOT contain a particular text string

Post by Q0xS » Thu, 25 May 2006 01:03:02

Data > Filter > AutoFilter > Custom > DoesNotContain > yourparticuartext

Vaya con Dios,
Chuck, CABGx3

 
 
 

Excel -find records which DO NOT contain a particular text string

Post by Bill Ridge » Thu, 25 May 2006 01:28:00

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