Dec 11 2022 03:16 AM
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._xlws.FILTER(" "=XLOOKUP(A8,_xlfn.ANCHORARRAY('" etc are getting added automatically.
Can someone help in resolving this issue.
Regards
Ramesh
Dec 11 2022 04:10 AM
ANCHORARRAY is not an Excel function. Could the workbook have been created (or edited) in GrapeCity SPREAD.NET?
Dec 11 2022 05:05 AM
@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.
Dec 11 2022 11:12 AM
Dec 11 2022 11:04 PM
Jan 29 2023 06:21 AM
Received an email notification from MS notifying the above issues are resolved wit the latest update 16.69.1, I downloaded it and checked all formulas are working fine now