In this article, you will learn how to use the Filter function in Google Sheets. The formula is helpful when you need to pull out specific information under condition(s).
The general syntax is as follows:
Range: This is the source data to which the FILTER function applies conditions. The FILTER function projects only information that meets the requirements defined.
Condition1: The first condition data must meet to be shown by the FILTER formula.
Condition2(Optional): You can include more than one standard if needed.
Note: all conditions should be the same type (row or column). Using both row and column conditions is not allowed. Also, condition arguments should have precisely the same length as “range”. Lastly, do not forget secure enough space for the data pulled out.
The FILTER function is helpful when you need to pull out or focus on specific data or information that meets the criteria.
Assume you have a profit list that contains the project name, project leader, budget, and deadline. You want to pull out the data on the projects that meets specific criteria. Before doing that, see the following example showing how to excerpt a part of the original data set. Imagine you are going to check each budget amount equal to or more than $5,000.
In this example, the formula in cell G3 contains the following arguments.
As you can see, you can select the same range for both “range” and “condition”. Note you don’t need to enclose these marks, “>” and “=”, with quotation marks in this formula. Don’t forget to prepare a table header and enough space for the formula to spread pulled values.
If you want to search the data set for projects whose leader is “Olivia”, you can enter the “=FILTER(C3:C12, C3:C12=”Olivia”)”. If you need to sort the projects whose deadline is on or earlier than “7/1/2022”, you can use the formula like “=FILTER(E3:E12, E3:E12<=date(2022,7,1)”.
The following example shows how the function works with multiple conditions. Assume you want to see projects that meet the following requirements.
In this example, the formula in cell B16 contains the following arguments.
The formula returns values in the same number of columns in the case of conditions by column (this example) and in the same number of rows when requirements are based on row values. You can enter requirements by cell reference as well as shown above.
If you don’t get the right answer to your question in this article or you have other questions related to filtering, you may find the answers in the following articles.
Formulas for filtering
UNIQUE Function in Google Sheets: Explained - show unique values without duplications
Google Sheets’ functions for filtering
Filter in Google Sheets: Explained - sort items quickly
Filter Views in Google Sheets: Explained - sort items and share the filter with your collaborators
Learn how to do this step-by-step in the video below 👇