SPILL!

[Crambone]

How do I get rid of the SPILL error?

[#2]

@Crambone 

https://support.microsoft.com/en-us/office/how-to-correct-a-spill-error-ffe0f555-b479-4a17-a6e2-ef9c...

[#3]

If you're getting a spill error, your formula in B1 for example is =A1:A5, will return a 5 row long result pulled from A1:A5 that will fill down B1:B5. If anything is within that range, you'll get the spill error. Same thing for horizontal spills.