A formula that returns multiple results which automatically 'spill' into neighboring cells.
Try it with AIDynamic arrays let one formula output many values at once. Functions like FILTER, SORT, UNIQUE, and SEQUENCE spill their results across a range that resizes automatically as the source data changes.
=UNIQUE(FILTER(A2:A100, B2:B100>0))Microsoft 365 and Excel 2021+. Older versions need Ctrl+Shift+Enter array formulas instead.