Pick rows with FILTER

FILTER(what to show, which rows) returns only the rows where the test is TRUE.

5 exercises in this lesson are part of ExcelHero Pro.