From the course: Excel: Lookup Functions in Depth

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Filter data and return matching records with the FILTER function

Filter data and return matching records with the FILTER function

From the course: Excel: Lookup Functions in Depth

Start my 1-month free trial

Filter data and return matching records with the FILTER function

“

- [Instructor] Excels filtering capability is generally considered pretty easy and a great tool for narrowing down a list, but there are times when you want to hold on to that list and at the same time see a filter list, perhaps off to the right here. I've got this list in columns A through E on this worksheet called Filter Function. Filter is a new function, a dynamic array function that allows us to come up with multiple results, by writing a formula in a single cell. So we're interested in showing just the people who have been here 15 or more years. In cell G2, I'll use the Filter Function. Now, for the result I don't necessarily want to show all the columns, I might want to show the data and it does go down to row 999, but the data only for employees, departments, hire date and years, I don't care about the salaries for the moment. Highlight down to row nine, then I'll type in the final 99 to go down to row 999…

Contents