dabenavidesd
New Member
- Joined
- Apr 29, 2014
- Messages
- 11
Hi, I wanted to filter by "not in this column criteria" in boolean form ... OR ... OR like this:
<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>
And it turns out it doesn't filter anything.
Note 1: I can't make this example smaller, because it will work if I just leave 1 criteria like <>Davolio, but I want dismiss hundreds of criteria from thousand rows table.
Note 2: Actual contents of criteria tange is:
="<>Davolio"
="<>Buchanan"
="=Suyama"
Can you explain me why is this behavior ocurring?
Thanks in advance
Type</SPAN> | Vendor</SPAN> | Sales</SPAN> |
<>Davolio</SPAN> | ||
<>Buchanan</SPAN> | ||
=Suyama</SPAN> | ||
Type</SPAN> | Vendor</SPAN> | Sales</SPAN> |
beverage</SPAN> | Suyama</SPAN> | 5122 $</SPAN> |
Meet</SPAN> | Davolio</SPAN> | 450 $</SPAN> |
food</SPAN> | Buchanan</SPAN> | 6328 $</SPAN> |
food</SPAN> | Davolio</SPAN> | 6544 $</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL></COLGROUP>
And it turns out it doesn't filter anything.
Note 1: I can't make this example smaller, because it will work if I just leave 1 criteria like <>Davolio, but I want dismiss hundreds of criteria from thousand rows table.
Note 2: Actual contents of criteria tange is:
="<>Davolio"
="<>Buchanan"
="=Suyama"
Can you explain me why is this behavior ocurring?
Thanks in advance