Explanation
This example uses the UNIQUE function together with the FILTER function.
For more examples of operators in formula criteriasee this page.
UNIQUE then removes duplicates, and returns the final array:
UNIQUE and FILTER are dynamic functions.
If data in B5:B16 changes, the output will update immediately.
The output from FILTER is dynamic.
If source data or criteria change, FILTER will return a new set of results.
This makes FILTER a flexible way to isolate and inspect data without altering the…
