Spill Range

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.

© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited TopPrevNext