Results 1 to 3 of 3

Thread: Dynamic Array Formulas now available?

  1. #1
    Acolyte Nick Burns's Avatar
    Join Date
    May 2017
    Posts
    48
    Articles
    0
    Excel Version
    Office 365

    Dynamic Array Formulas now available?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    According to Office Watch Dynamic Arrays are now available across all versions of Excel sans Excel Online

    I have O365 Excel V1907 Build 11901.20176 according to the article, but when I can't find the formulas in the formula list and when I try to use one, like SORT(), Excel gives the following error:

    That function isn't valid.

    In the past I would #NAME? error.

    So what gives?
    Oh... by the way, YOU'RE WELCOME!

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,239
    Articles
    0
    Excel Version
    Office 365 Subscription
    Working here, but I am on the insider programme.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Acolyte Fluff's Avatar
    Join Date
    Sep 2018
    Posts
    81
    Articles
    0
    Excel Version
    O365
    @Nick Burns
    I get exactly the same thing.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •