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.
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext