Results 1 to 5 of 5

Thread: =UNIQUE coming to O365?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2016
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default =UNIQUE coming to O365?

    Hi all

    Does anyone have an ideas of when the new array formulas are coming to excel O365?

    They were released to insiders exactly one year ago now but still no sign for normal users.

    Apologies if there is already a thread on this, I I did a quick search but couldn't find

    Thanks
    Joe
    Last edited by JoeVBAHelp; Oct 1st, 2019 at 06:53 AM. Reason: Add ?

  2. #2
    Board Regular
    Join Date
    Jul 2014
    Location
    The Netherlands
    Posts
    1,263
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default Re: =UNIQUE coming to O365?

    Hi,

    As to my knowledge the UNIQUE function is one of the new beta features, and not even available to all office insiders but a subset of Office Insiders at this time.
    Microsoft announced last september '18, they would continue to optimize the new features over the next months and when ready, a release them to all Office Insiders would follow, and subsequent to Office 365 users.
    Even the Insiders community doesn't have more info yet. Perhaps the MVP's ?
    --------------------------------------------------------------------------------
    If you found my answer helpful, please hit the Like or Thank button.

    Please follow the forum Rules and Guidelines and use Code tags around your VBA code.

    Remember: test VBA code always on a copy of your file because usually you can't use <undo>

  3. #3
    New Member
    Join Date
    Aug 2016
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: =UNIQUE coming to O365?

    Ok thanks jorismoerings

    Such a shame it is taking so long. Currently means that I have to use Google sheets instead on excel, or vba which is rather try and avoid.

    Will be a game changer when it finally arrives

  4. #4
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    11,234
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    2 Thread(s)

    Default Re: =UNIQUE coming to O365?

    Quote Originally Posted by JoeVBAHelp View Post
    Ok thanks jorismoerings

    Such a shame it is taking so long. Currently means that I have to use Google sheets instead on excel, or vba which is rather try and avoid.

    Will be a game changer when it finally arrives
    If doing a vertical list with data in A2:A12, Formula in B2 and dragged down....

    =IFERROR(INDEX($A$2:$A$12, MATCH(0, INDEX(COUNTIF($B$1:B1, $A$2:$A$12), 0, 0), 0)), "")
    Last edited by MARK858; Oct 16th, 2019 at 05:01 AM.
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, RoryA addin (Win & Mac) or Borders-Copy-Paste

  5. #5
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    11,234
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    2 Thread(s)

    Default Re: =UNIQUE coming to O365?

    Demo table of previous post in link below

    https://www.mrexcel.com/forum/test-h...ml#post5357053
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, RoryA addin (Win & Mac) or Borders-Copy-Paste

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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