MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.


Posted by martin on December 05, 1999 7:46 AM

you have to use the advanced filter-function, where you can define a criteria range. the criteria range must have the same header as the column in which you have the abbreviations for the states...just tested it, that works...the only discomfort is, that you have to copy the data to another location in your spreadsheet....martin

Posted by jack on December 05, 1999 11:21 PM


create additional tag column
select MN
mark column next to them with asterisk (or with any character)
select WI
mark column next to them with asterisk (or with any character)
...
select asterisk

j.