Hi,
In my Excel 2019 64 bit the "UNIQUE" function is not showing in the list of functions while typing "=" and "UNI"
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
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.
Is the "Stocks" & "Geography" data types also for office 365? . these are also not showing in standalson office 2019
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.
They are currently only available to users on the insider programme. See this note from the page I linked to above:
They are not yet availiable in the general 365 release. Nor is UNIQUE.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.
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.
Alright. Sadly I did expect them while upgrading.
Thanks for your time to make me understand the matter.
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.
I will wait for 2022 version
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.
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks