This article will teach you how to transfer data from one spreadsheet to another in Microsoft Excel if your copy and paste function is not working. This article will show you three methods of how to ...

Once deleted, add the array formula again in the first cell and then copy it down to the required cells. Read: Excel ran out of resources while attempting to calculate formulas.