Forum Discussion
#NAME? error for ANCHORARRAY function
Hello, I have just been sent a spreadsheet, with #NAME? errors in some of the spreadsheets. These all have ANCHORARRAY functions included. When opened in Google Sheets it says Unknown Functi...
The workbook has probably been created in SPREAD.net.
In Excel, you can try changing - for example - ANCHORARRAY(B2) to B2#