Table of Contents
Google Sheets offers a convenient and efficient way to filter data by multiple values in a single column. This feature allows users to easily sort and organize their data based on specific criteria. To filter a column by multiple values, simply select the desired column and click on the “Filter” button in the toolbar. Then, click on the drop-down arrow next to the column header and select “Filter by condition.” From there, users can input the desired values or select them from a list. This will filter the column to display only the rows that meet the selected criteria. This function is particularly useful for analyzing large datasets and extracting specific data points.
Google Sheets: Filter a Column by Multiple Values
You can use the following basic formula to filter a column by multiple values in Google Sheets:
=FILTER(A1:C11,REGEXMATCH(A1:A11,"string1|string2|string3"))
This particular formula will filter the rows in the range A1:C11 to only show the rows where the value in the range A1:A11 is equal to either string1, string2, or string3.
The following example shows how to use this formula in practice.
Example: Filter Column by Multiple Values in Google Sheets
Suppose we have the following dataset that contains information about various basketball players:
Now suppose we’d like to filter the dataset to only show rows where the Team column contains Heat or Celtics.
To do so, we can use the following formula:
=FILTER(A1:C11,REGEXMATCH(A1:A11,"Heat|Celtics"))
The following screenshot shows how to use this formula in practice:
Notice that the filtered dataset only contains the rows where the team is equal to Heat or Celtics.
Also note that you can filter for rows where the team name is not equal to Heat or Celtics by using the NOT function outside of the REGEXMATCH function as follows:
=FILTER(A1:C11, NOT(REGEXMATCH(A1:A11,"Heat|Celtics")))
The following screenshot shows how to use this formula in practice:
The following tutorials explain how to perform other common tasks in Google Sheets:
Cite this article
stats writer (2024). How can I filter a column in Google Sheets by multiple values?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-filter-a-column-in-google-sheets-by-multiple-values/
stats writer. "How can I filter a column in Google Sheets by multiple values?." PSYCHOLOGICAL SCALES, 26 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-filter-a-column-in-google-sheets-by-multiple-values/.
stats writer. "How can I filter a column in Google Sheets by multiple values?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-filter-a-column-in-google-sheets-by-multiple-values/.
stats writer (2024) 'How can I filter a column in Google Sheets by multiple values?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-filter-a-column-in-google-sheets-by-multiple-values/.
[1] stats writer, "How can I filter a column in Google Sheets by multiple values?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I filter a column in Google Sheets by multiple values?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.