Forum Discussion

Awfimohammed's avatar
Awfimohammed
Copper Contributor
Nov 30, 2020

SPILL! Error Merged Cells

Team,

 

I have a SPILL error on my spreadsheet while trying to equate merged array with another merged array from another sheet. Note that both arrays are same location same size, but when I I try to do the calculation it gives SPILL error due to merged cells.

 

I send the spreadsheet to a friend, and it worked fine. Could that be something from my version or the settings I have?

 

Please assist.

excel

7 Replies

  • ExcelExciting's avatar
    ExcelExciting
    MVP
    Nov 30, 2020

    Hi Awfimohammed 

     

    Can you please attach the sample file, which will give us better idea to support you 

     

    Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

    If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.

     

      • ExcelExciting's avatar
        ExcelExciting
        MVP
        Dec 01, 2020

        Hi Awfimohammed,

         

        please check this link, were I have recently explained about the #SPILL! error, your case the error is appearing because the cells are merged. What you can do here in this scenario apply implicit intersection using the @ operator. That will resolve your issue 

         

        =@'Sheet 1'!B4:D5

         

        excel spill error with row multiplication - Microsoft Tech Community

         

        Hope this might be helpful for you 

         

        Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

        If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.

Resources