In this tutorial, you will learn how to filter by list of values in Excel.
A variety of data can be “filtered” using the FILTER function using provided criteria. An array of values from the initial range that match is the outcome. In plain English, the FILTER function will apply one or more logical checks to a set of data in order to extract matched records. A variety of formula conditions can be included in the logical tests that are offered as the include argument. FILTER can, for instance, find data that falls within a given year or month, has a particular word, or has values higher than a predetermined limit.
Once ready, we’ll get started by utilizing real-world examples to show you how to filter by list of values in Excel.
Table of Contents
Filter by List of Values in Excel
Before we begin we will need a group of data to filter by list of values in Excel.
Step 1
First, you need to have a clean and tidy group of data to work with.
Step 2
In this example, we want filter by list of values for students naming Jean, Sean and Chuck. To do so, we can simply insert the following formula =FILTER(A2:B9,COUNTIF(D1:D4,A2:A9)).
Step 3
Once we are done, you will be able to filter by list of values in Excel.