How do I filter one column in Google Sheets based on values in another column?

By /

The process of filtering one column in Google Sheets based on values in another column involves using the filter function to display only the desired data in the first column, according to the specified criteria in the second column. This allows for more efficient data management and analysis, as only relevant information is displayed. To filter, select the first column, then click on the filter icon and choose “Filter by condition” to specify the criteria based on the values in the second column. This feature in Google Sheets can greatly enhance the organization and manipulation of data for various purposes.

Google Sheets: Filter One Column Based on Another Column

You can use the FILTER function along with the MATCH function in Google Sheets to filter the values in one column based on the values in another column.

For example, you can use the following syntax to filter the range A2:B12 for rows where the value in the range A2:A12 contains one of the values from the range D2:D4:

=FILTER(A2:B12,MATCH(A2:A12,D2:D4,0))

The following example shows how to use this formula in practice.

Example: Filter One Column Based on Another Column

Suppose we have the following dataset that contains information about various basketball players:

Suppose we define a list of specific team names in column D and we would like to filter the rows in the dataset to only contain the team names in column A that belong to column D:

To perform this filter, we can type the following formula into cell A14:

=FILTER(A2:B12,MATCH(A2:A12,D2:D4,0))

The following screenshot shows how to use this formula in practice:

Google Sheets filter column based on another column

Notice that the dataset is filtered to only show rows where the team name in column A is equal to one of the team names in column D.

Note: You can find the complete documentation for the FILTER function in Google Sheets .

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

x

Related terms:

  1. How can I filter one column in Google Sheets based on another column?
  2. Google Sheets: How can I filter a column by multiple values?
  3. How can I count unique values in Google Sheets based on multiple criteria?
  4. How can I use Google Sheets to return multiple values based on a single criteria?
  5. How can I remove duplicate rows in Google Sheets based on one column?
  6. How to Filter by List of Values in Google Sheets?
  7. How can Google Sheets return multiple values based on a single criteria?
  8. How can I filter rows in PySpark based on values in a list?
  9. # Check if One Column Value Exists in Another Column in Google Sheets
  10. How can I count a column in Google Sheets if another column meets certain criteria?