Lesson Description

Explore how to filter non-adjacent columns in Excel using the FILTER function. Often, when working with large datasets, you may need to extract specific columns that are not next to each other. The FILTER function can be adjusted to achieve this by specifying the desired columns and applying multiple criteria. We walk through an example of filtering student exam data to return only the relevant columns such as student name, exam, and month all while excluding unwanted columns, all based on specific criteria like the exam type and month.