Searching Filter and Filter by Condition

In this chapter we will cover the topic of Searching Filter and Filter by Condition. You will learn how to use these tools to more easily analyze data in your spreadsheet by hiding unnecessary rows and focusing only on important information. This is especially useful when working with large datasets, when you need to filter rows based on specified conditions.

How to set up a filter

Go to the toolbar and select Data → Create a filter.

After this, filter icons will appear in the header row of the table, which you can use to set up searches by columns.

Search Filter

• Click the filter icon in the desired column;
• Click Clear to reset the current selected values;
• Enter a keyword in the search bar to find rows containing that text;
• Click Select all to choose all rows that match your query;
• Click OK.

Filter by Condition

• Click the filter icon in the desired column;
• Select Filter by condition and set a condition for filtering;
• Click OK.

Example of use

Open our spreadsheet with airline ratings data.

• To find airlines with an overall rating higher than 8, apply the filter in the Overall Rating column:
  • Filter by condition → Greater than → Enter 8 → Click OK;
• To filter verified reviews, use the condition in the Verified column:
  • Filter by values → click Clear → Enter True → click Select all → Click OK.