Spill Range
Available in Excel 2021 and Excel 365.
Formulas that return more than one value but cannot populate all the adjacent cells will return #SPILL!
Spill range operator (# character)
To refer to the spill range, put a hash tag or pound symbol (#) after the address of the upper-left cell in the range.
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext