Cellwise · Modern Excel: formulas that spill

FILTER with several conditions

AND, OR and sorted results.

You can pull out exactly the rows a question needs.

This lesson has 4 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.