FILTER practice exercises
Return every row that matches, not just the first: FILTER spills the matching rows into the cells below, with one condition, two conditions or a message when nothing matches.
- 1Keep the rows for one region with FILTERIn E2, list the rep and sales of every North row. FILTER the columns you want, B2:C7, by a test on the region column: A2:A7="North".
- 2FILTER with two conditionsPremiumIn E2, list the rep and sales of the North rows with sales over 300. Multiply the two tests so a row must pass both: (A2:A9="North")*(C2:C9>300).
- 3A message when FILTER finds nothingPremiumIn E4, list the reps whose sales reached the target in F1. Nobody did this month, so give FILTER a third argument to show "No one" instead of an error.