Excel Video 388 discusses the differences between AND filters and OR filters in Excel. Most of the filtering techniques we’ve discussed will let you filter for a AND b, but not a OR b. Advanced filters will let you use OR filters if you set things up correctly and use the right syntax. We’ll walk through the setup in Excel Video 388, including inserting several rows above the table and the Advanced Filter menu settings.
The tricky part of advanced filters is the syntax. Notice that when we filter for Downtown, the syntax is =”=Downtown” to get rows equal to downtown. Stay tuned. There are a bunch more things we can do with advanced filters. I look forward to seeing you then.
