How to Filter by List of Values in Google Sheets

Filtering by a list of values in Google Sheets can be done easily using the "Filter" function or by creating a filter view. Here's how to do it:

Using the "Filter" function:

  1. Create a new sheet or use an existing sheet with your data.
  2. In a separate column or sheet, list the values you want to filter by.
  3. In a blank cell, use the FILTER function to display the filtered results. The syntax for the FILTER function is:
=FILTER(range, condition1, [condition2, ...])


Let's say you have a list of fruits and their prices in columns A and B, and you want to filter the list to show only specific fruits.

A          B
1  Fruit       Price
2  Apple       1
3  Banana      0.5
4  Orange      0.75
5  Pineapple   2
6  Mango       1.5
7  Grape       0.8

In a separate column or sheet, list the fruits you want to filter by:

1  Apple
2  Orange
3  Pineapple

Now, use the FILTER function in a blank cell to display the filtered results:


This will display the filtered list of fruits and their prices:

Apple      1
Orange     0.75
Pineapple  2

Creating a filter view:

  1. Open your Google Sheet with the data you want to filter.
  2. Click on the "Data" menu and select "Filter views" > "Create new filter view."
  3. A new filter view will be created with filter icons in the column headers.
  4. Click on the filter icon in the column header that you want to filter by a list of values.
  5. In the filter menu, uncheck "Select all" to deselect all items.
  6. Manually check the values you want to filter by and click "OK."
  7. The sheet will now display the filtered data based on the selected values. You can also name the filter view and switch between different filter views as needed.

Remember that filter views are only visible to you, so other users with access to the sheet won't see your filter view unless they create their own or you share the filter view link with them.

Did you find this useful?