The filter option helps you to filter 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 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 age are greater than 35.

Using AND operator

Sheet Result

Using OR operator

Sheet Result

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.

Did this answer your question?