The Filter option helps you to filter a few values from the entire sheet depending upon the parameters you want. You can use multiple filters and group them using And/ Or.
When you use “And” to group filters, then the entries that are true for both the filters will appear.
When you use “Or” to group filters, then the entries that are true for both or any one of the filters will appear.
For example, you can use filters to see all the employees of just the sales department by using the department as the filter parameter. You can add a filter to show the employees with age more than 35 to that by using an “And” operator and you will see sales department employees whose age is more than 35. If you use an “Or” operator instead, then you will see all the employees of the sales department as well as employees of all the other departments whose ages are greater than 35.
Using AND operator
Using OR operator
To add a filter click on the filter option in the top bar and a drop-down will appear. You can then add the column, operator, and value to set the filter.
You can read about the different operators you can use with each column type here.