The Standard Filter is a nice tool. But when things get complicated, it's about the logic, not the software. Make sure you keep the logic solid as you build the filter.
Let's say you've got this list of people. We'll keep it short just to simplify the example.
You want to build a filter that will filter OUT everyone EXCEPT:
people from Kalispell whose names are also either Hanson or Miller.
Taking a look at the data, the highlighted names are the only ones who fulfill the full criteria.
There are other people named Hanson, and Miller (and Hansen) but these are the only ones with the right names who are also from Kalispell.
So select the data, choose Data > Filter > Standard Filter, and you might build this filter.
Hanson, OR Miller, AND Kalispell.
But you get this data, because what the filter really says is
Hanson
OR Miller AND Kalispell
What you need to do is repeat one of the criteria, so you have two sets. Like this:
This says
Kalispell AND Miller
OR
Kalispell AND Hanson
So you get this correct result.
In OpenOffice 3.2 there are eight spaces for your filter criteria, so you do have the room to put in all the necessary logic.
