advanced filter question
Posted by Jeffrey Rajanen on December 03, 1999 11:19 AM
I have a database that contains 886 banks, date of failure, assets, location, and some other headings. I need to know how to filter the list so that only those banks that are in MN, WI, SD, and WI. The problem is, the location heading lists the banks by city and state. Ex: (Tacoma, WA). I tried running a custom auto filter, but I can only get two sets of criteria out of it. How do I get it so that I can have it filter out four states instead of only two? Please reply. Thanks much.