Is it true that the FILTER function is only available to the Office 365 subscribers? It would explain why it doesn't work for someone else that I created a spreadsheet for.
Is it true that the FILTER function is only available to the Office 365 subscribers? It would explain why it doesn't work for someone else that I created a spreadsheet for.
Yes, that's the case
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hey - I'm unsure if that's true.
I need to use the FILTER function. I previously had 2016 professional version and have just purchased a subscription for 365:
https://www.microsoft.com/en-nz/micr...ot:overviewtab
Just installed office now and I get the same error when using the FILTER function - stating 'That function isn't valid'.
Can anyone confirm which version of office supports this filter?
Thanks
@ Ciggy36
Have you tried performing an Office 365 update?
Dave
Yes - when I goto my account page - it now states 'Subscription Product' 'Microsoft Office 365'
Then when I check to do an update it says the latest version is on my computer
Attached is a pic of my account page:
Attachment 743650
The OP asked:Is it true that the FILTER function is only available to the Office 365 subscribers? It would explain why it doesn't work for someone else that I created a spreadsheet for.
See: https://support.microsoft.com/en-us/...c-4877ad80c759
@Ciggy36: don't hijack other users' threads.Note: This function is currently available only to Microsoft 365 subscribers.
Last edited by TMS; 08-11-2021 at 02:17 AM.
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.
Thanks for the link confirming the FILTER function is only available to Microsoft 365 users.
My user is insisting she is a 365 subscriber, which I'm presently looking into.
I can't really understand the logic of restriction this Function, or other Functions, unless it's a new (to me) sales tactic.
It's quite normal for new versions of software to be better than their predecessors and to have new functionality. I'm really not sure what's so surprising to you about this.
I suggest you ask your user to force an update - if they have 365, this will resolve any issues. If they don't it will prove they don't.
I have suggested the update, so hopefully that will put matters right.
I don’t make a habit of creating spreadsheets for others and not needed an awareness when new functions become active, so I haven’t faced this problem before.
Thanks for your help. I must be more attentive.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks