Cellwise · Modern Excel: formulas that spill

The FILTER function

Pull out matching rows with a formula.

You can pull out matching rows with one formula.

This lesson has 3 steps of hands-on practice in a live spreadsheet. Every formula you write is also tested on data you haven’t seen, so you know it really works.