SPILL error is caused when a formula with multiple results cannot display its output array as those cells already contain some data. A simple solution to this problem is to clear contents of the cells in the spill range.