Use a Single Formula to Display Results in a Range of Cells with the Excel Spill Feature

The #Spill feature in Excel is nice for applying a single formula to a range of cells. Instead of using a single absolute cell reference and copying (filling) that same formula to the range, we can write one formula that spills the correct, calculated values to the adjacent cells.

Category