How to use the FILTER function in Google Sheets?

account_box
Syntactica Sophia
2 years ago

The FILTER function in Google Sheets is a powerful tool that allows you to extract specific data from a larger set of data based on certain criteria. With the FILTER function, you can create custom views of your data, filter out irrelevant information, and make it easier to analyze and understand your data.

The basic syntax of the FILTER function is as follows:

=FILTER(range, condition1, [condition2, ...])

The 'range' parameter specifies the data you want to filter, while the 'condition' parameters specify the criteria you want to use to filter the data. For example, if you want to filter a list of sales data to show only the sales made by a specific salesperson, you can use the following formula:

=FILTER(A2:C10, B2:B10='John Smith')

This formula tells Google Sheets to filter the data in cells A2 through C10 to show only the rows where the value in column B is 'John Smith'.

You can also use multiple conditions to filter your data. For example, if you want to filter a list of inventory data to show only the items that are in stock and have a price less than $50, you can use the following formula:

=FILTER(A2:C10, B2:B10='In Stock', C2:C10<50)

This formula tells Google Sheets to filter the data in cells A2 through C10 to show only the rows where the value in column B is 'In Stock' and the value in column C is less than 50.

The FILTER function is a versatile and powerful tool that can help you to better manage your data in Google Sheets. By using the right criteria to filter your data, you can create custom views that make it easier to analyze and understand your data.