+ Reply to Thread
Results 1 to 11 of 11

Excel 2019 functions are not showing

  1. #1
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Excel 2019 functions are not showing

    Hi,

    In my Excel 2019 64 bit the "UNIQUE" function is not showing in the list of functions while typing "=" and "UNI"
    Teach me Excel VBA

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Excel 2019 functions are not showing

    It's only available in Office 365 (subscription), not the standalone versions: https://support.office.com/en-us/art...a-40204fb85e1e
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Excel 2019 functions are not showing

    Is the "Stocks" & "Geography" data types also for office 365? . these are also not showing in standalson office 2019

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Excel 2019 functions are not showing

    I don't know - probably - Google them yourself as I did with UNIQUE.

    Yes, 365 only: https://support.office.com/en-us/art...8-f1a89e210877
    Last edited by AliGW; 11-02-2018 at 01:48 AM.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Excel 2019 functions are not showing

    They are currently only available to users on the insider programme. See this note from the page I linked to above:

    Note: June 12, 2018: These data types are currently beta features, and only available to a portion of Office Insiders at this time. We'll continue to optimize these features over the next several months. When they're ready, we'll release them to all Office Insiders, and Office 365 subscribers.
    They are not yet availiable in the general 365 release. Nor is UNIQUE.

    I hope that you have not just upgraded to 2019 expecting to find these subscription-only features.
    Last edited by AliGW; 11-02-2018 at 02:03 AM.

  6. #6
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Excel 2019 functions are not showing

    Alright. Sadly I did expect them while upgrading.

    Thanks for your time to make me understand the matter.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Excel 2019 functions are not showing

    You chose the wrong product. You should have upgraded to the subscription model, and then you would have got the features as soon as they are on general release, as I will. I am sorry for your mistake - I suspect a lot of people have been caught out by this. There's no guarantee that these features will ever appear in the 2019 standalone version.

  8. #8
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Excel 2019 functions are not showing

    I will wait for 2022 version

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Excel 2019 functions are not showing

    I suspect there will always be features that will not make it into the standalone versions: the subscription model is such good value for money, I find it hard to derive any real benefit from staying with the standalone model these days.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  10. #10
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Excel 2019 functions are not showing

    I think there should be another option to mark thread as "Not possible" as some times OP asks for something that is not possible.

    Anyway I have marked it "Solved" but not solved.

  11. #11
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Excel 2019 functions are not showing

    Well, that's not really the case here - you asked about what you called 2019 functions that are NOT Excel 2019 functions, so finding this out has solved the issue for you. They don't show because they are not there, not because it isn't possible to achieve. If you had an insider version of Office 365, you would find those functions. So 'not possible' would not be correct - it is possible, just not in your version.

    Marking the thread as solved means simply that the issue has been dealt with. I don't agree that there should be multiple options - one is enough.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Migrating Excel 2016 to Excel 2019
    By ImranBhatti in forum Excel General
    Replies: 8
    Last Post: 10-26-2018, 11:35 AM
  2. how to sort Week no- Year (04-2018, 05-2019, 07-2018) in pivot chart.
    By sahana108 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-23-2018, 09:07 AM
  3. Replies: 1
    Last Post: 02-10-2012, 05:27 PM
  4. Printing with functions showing?
    By atarikick in forum Excel General
    Replies: 5
    Last Post: 11-22-2009, 08:23 PM
  5. showing parameters on custom built functions
    By justin4480 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-17-2008, 02:41 AM
  6. Replies: 3
    Last Post: 04-12-2006, 04:20 AM
  7. Replies: 1
    Last Post: 07-20-2005, 12:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1