FILTER, SORT and UNIQUE

Build live lists and reports that expand automatically.

Practical example

=SORT(UNIQUE(FILTER(A2:A200, B2:B200="Open")))

Identify the source cells, apply the smallest reliable formula or tool, and test the result with changed data.