Forum Discussion

Brass Contributor

Dec 11, 2022

Issue with excel 365 for Mac - some formulas are not working

Hi Greetings I have excel 365 and using in Mac, some of the formulas like SORT, FILTER etc are not working. in the formula cells text "=INDEX_xlfn.ANCHORARRAY(", _xlfn._xlws.SORT(" , "=_xlfn._xlw...

Excel on Mac

office 365

dscheikey

Bronze Contributor

Dec 11, 2022

RameshYedhula A function like ANCHORARRAY() is not needed in Excel, because Excel automatically recognises array formulas and also automatically spills results if necessary.

Excel cannot use the ANCHORARRAY function when it is opened and "translates" incorrectly.

Your formula should look something like this in Excel:

=INDEX(1,SORT(FILTER(A1:A100,B1:B100=XLOOKUP(A8, etc

Since you have not published your complete formula here, the function given can only be an example. The way you wrote it down seems to be the completely wrong syntax.