Here I will show how to filter list with and / or condition
And Condition → Information that matches in a record
Or Condition → Information that either matches in a record
And Condition
- Filter the information that needs to be on the list
- Click ‘new condition’ → Select ‘And’ in the filter list
- Drop that information in item No. 1 in ‘And’
- Click ‘OK’
OR Condition
- Filter the information that needs to be on the list
- Click ‘new condition’ → Select ‘OR’ in the filter list
- Drop that information in item No. 1 in ‘OR’
- Click ‘OK’