Excel
=UNIQUE(SORT(...))Excel Spill Ranges: Master the # Operator for Dynamic Arrays
Master Excel spill ranges and the # operator to build formulas that update automatically as your data grows.
Explore ↗
#spill
1 formula guide
1 formula guide
=UNIQUE(SORT(...))Master Excel spill ranges and the # operator to build formulas that update automatically as your data grows.