How to filter more than two criteria

bknight
BronzeLounger
Posts: 1353
Joined: 08 Jul 2016, 18:53

How to filter more than two criteria

Post by bknight »

How could I filter on more than two criteria. My criteria choices are limited to two choices.

User avatar
HansV
Administrator
Posts: 78235
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: How to filter more than two criteria

Post by HansV »

You can select multiple items in the filter dropdown list.
If that isn't sufficient, you can use Advanced Filter. This lets you specify any combination of And and Or filters.
Best wishes,
Hans

bknight
BronzeLounger
Posts: 1353
Joined: 08 Jul 2016, 18:53

Re: How to filter more than two criteria

Post by bknight »

HansV wrote:
15 Jan 2021, 19:28
You can select multiple items in the filter dropdown list.
If that isn't sufficient, you can use Advanced Filter. This lets you specify any combination of And and Or filters.
These are all I have. is there a way to make an or statement into the fields?
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78235
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: How to filter more than two criteria

Post by HansV »

Please take a look at the link in my previous reply. It explains how to create And and Or links in the Criteria range.

Here is a very simple example:

S0071.png

A17:A20 is the Criteria range. Since the names are below each other, it is an OR condition.
When I click OK, only the rows that contain Aisha, Mary or Dave will be shown.

Another example:

S0072.png

Here, the Criteria range is A17:B18. Since the name and age are in one row, it is an AND condition.
When I click OK, only the row that contains Anne with age 51 will be shown.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

bknight
BronzeLounger
Posts: 1353
Joined: 08 Jul 2016, 18:53

Re: How to filter more than two criteria

Post by bknight »

Yes, but that requires setting up a criteria range along with defining it and the database range. This was to be a quick and dirty filter discarsed at the end of the session.
Thanks

User avatar
HansV
Administrator
Posts: 78235
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: How to filter more than two criteria

Post by HansV »

You cannot have it both ways... :shrug:
Best wishes,
Hans