Share via

Filter function missing in Excel

Anonymous
2020-05-12T08:58:05+00:00

I am on Office365 ProPlus, I was able to use Filter function in Excel before but now its not showing anymore. Only =Filterxml is showing which is not the function I want to use

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-05-12T09:41:55+00:00

    Hi VillmarDan,

    Thank you for posting your question in this community. May I know which Office version and update channel you are using? You can go to File >Account >Under Product Information to find details.

    Currently, FILTER function is available for Microsoft 365 subscriber in Monthly channel. If you are in Semi-annual channel, it would be available later this year.

    For your information:

    FILTER function

     

    Best regards,

    Dihao

    0 comments
  2. Anonymous
    2020-05-12T10:11:07+00:00

    HI Dihao,

    I am currently on Monthly channel but the Filter function is not showing.

    Thanks,

    Dan

    4 people found this answer helpful.
    0 comments
  3. Anonymous
    2020-05-12T11:34:05+00:00

    Hi Dan,

    Thank you for your quick updates and sharing the information. If you have updated to the latest version of Office application in Monthly update channel, the problem should be related to the release schedule of this feature.

    Based on my experience, the newest features release will be depended on the country, regions, tenant or even individual account in the same tenant. It may take sometimes to fully rolling out this feature to all Monthly Channel. Sorry for the inconvenience caused.

     

    For your information:

    When do I get the newest features for Microsoft 365?

    Best regards,

    Dihao

    0 comments