View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default 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