Forum Discussion

Bobby_Notlok's avatar
Bobby_Notlok
Copper Contributor
Jul 31, 2023

Sorting a table works in Excel but displays error on iPhone

Hello,

I have a spreadsheet with a sort formula to place in descending order about 9 rows and two columns.

It works perfectly in my Mac but displays a #¿NAME? error when I try to open it in my iPhone.

The formula that shows in the cell in the iPhone is =ARRAY_CONSTRAIN(ARRAYFORMULA(_xlws.SORTBY(BI16:BJ14,BJ6:BJ14,-1)), 9, 2)

The formula in the computer is =SORTBY(B16:BJ14;BJ6:BJ14;-1)

 

Excel on mobile
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Aug 01, 2023
    It seems you are opening the file with Goggle Sheets and SORTBY() is not a valid function in Google Sheets.

Resources