Returns a subset of a range that meets criteria (the function version of filtering).
=FILTER(A2:B10, B2:B10="Yes") returns only rows where column B is "Yes".
