Forum Discussion
ituryu
Jan 22, 2020Brass Contributor
#SPILL! From a Referenced Merged Cell.
Hi everyone, I have a spreadsheet that I'm trying to build for my work flow to enable track my daily sales activities and simultaneously compute my percentage earnings per customer. For me to achieve this I need to merge certain number of rows and work with two separate worksheets, thus I can reference dates, customer names for the input sales sheet to the salary sheet but immediately I referenced it, there was a #SPILL!
Please how do I eliminate this error because for my 2019 worksheet, this did not appear.
That means you are on dynamic array version of Excel and your formula returns an array for which not enough space. 2019 returns only first element of such array. Better to rework the formula, but you may try to put in front of it @ sign. For example, if your formula
=INDEX(...) convert it to =@INDEX(...)
- Carrey1608Copper ContributorHi Sergei Baklan, I'm having a problem too in understanding the spill function.
When i entered a date in a cell, but i merged with with other two cell due to the small column I created. But when i want to link that date into other cell, it appears as it is in one cell, but it appears "0" in the next two cell next to it, and I cant delete that 0. Can u help?- PeterBartholomew1Silver ContributorIt depends on the nature of the link.
=A1:C1 will give the date followed by 0s to fill the array to 3 values
=A1 will just give the date
The manual process of selecting cells is somewhat messy in the presence of merged cells and the normal advice is to avoid their use where possible.
- ituryuBrass Contributor
ituryu , you are welcome