Assuming text is running in col A, in A2 down
Put in say, E2:
=IF(A2="","",IF(ISNUMBER(MATCH(A2,{"aaaa","bbb","c cc"},0)),"",1))
Copy E2 down, then autofilter col E for 1's to get the exceptions
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dolphin" wrote:
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