View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dolphin Dolphin is offline
external usenet poster
 
Posts: 9
Default Advanced Filter: Inverse

Hi,

I want to filter a list of data whereby it is the exception, ie, text<aaa
AND text<bbb AND text<ccc. I tried the following but could not. Please help.
**************************
text text text
<aaa
<bbb
<ccc
**************************
and I also tried this:
**************************
text
<aaa
<bbb
<ccc
**************************


Is this wrong?

Thanks,
Val