Advanced · Lesson 11 of 12
Formulas that fill many cells
One formula, many results
Some formulas give back a whole list, which flows into the cells below. This is called spilling, and it needs Excel 2021 or Microsoft 365.
=UNIQUE(A2:A6)Live filtered lists
FILTER shows the rows that pass a test, and updates when the data changes.
=FILTER(A2:B5,B2:B5>100)Leave room to spill
If something is in the way you will see #SPILL!. Clear the cells in the dashed outline to fix it.