• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Introducing and activating xlfn equations in Office 2016

Hany ali

Active Member
hello, Distinguished teachers, please kindly help me
Is there a way to enter and activate a set of equations such as XLFN in Excel 2016
Such as _xlfn._xlws.SORT
And _xlfn.UNIQUE
And _xlfn._xlws.FILTER
And _xlfn.SINGLE
Thank you very much.

GraH - Guido

Well-Known Member
Hi those (dynamic array) functions are solely available for 365 insider. So not even publicly available.


Active Member
Whenever you see the _xlfn. it means that function is not available in your version of Xl, it is there to prevent the formulae from breaking.
Also those functions will never be available with Xl2016