By Michael Nocito, data analyst · Published August 8, 2026
By the end of this page you can pull a distinct list out of a column, extract every row matching a condition, sort a result without touching the source, chain all three into one line, and read the two error messages that only exist in this part of Excel. It is about twenty-five minutes, and every output below was produced by running the formula in Excel on a sixteen-row table.
Here is what to do right now, on a column you keep de-duplicating by hand. Click an empty cell to the right of your data and type =SORT(UNIQUE(A2:A500)). Press Enter once. A sorted list of every distinct value appears below the cell, it updates itself when the data changes, and you never touch it again.
The short version: a formula can return more than one value, and Excel puts the extra values in the cells underneath. That is called spilling, and it is the whole feature.
One formula filling many cells is the idea, so it gets the picture.
