+ Reply to Thread
Results 1 to 4 of 4

excel 2019 no filter function

  1. #1
    Registered User
    Join Date
    01-26-2015
    Location
    sacramento ca
    MS-Off Ver
    10
    Posts
    13

    excel 2019 no filter function

    I have the filter on the dash board, but there is no filter that comes up in functions? is my excel too old?
    is there some way to add it to my configuration?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,140

    Re: excel 2019 no filter function

    Despite what it says on the web page for the FILTER function, I am reliably told that it is not available in 2019.

    is my excel too old?
    Yes

    is there some way to add it to my configuration?
    No, unless you upgrade to 365 or 2021.
    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


  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: excel 2019 no filter function

    To confirm. There is an error on Microsoft's own www. FILTER is NOT available in Excel 2019. It never will be...
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,140

    Re: excel 2019 no filter function

    If you are using 2019, please update your profile.

+ 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. Alternative for SEQUENCE function on Excel 2019
    By charitos in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-14-2021, 10:33 AM
  2. Import_mail function gives error on office 2019
    By gicchesto in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-06-2021, 11:42 AM
  3. Excel 365 VS 2019 Suite
    By ExcelFan117 in forum Office 365
    Replies: 2
    Last Post: 10-08-2020, 07:04 AM
  4. Macro filter date works in Excel 2010 and not in 2019
    By Berna11 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2020, 07:11 PM
  5. Replies: 6
    Last Post: 07-07-2020, 12:26 PM
  6. [SOLVED] VBA (or function) to turn a date into a number i.e 12/31/2019 to 2019.12
    By lynnsong986 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-23-2019, 03:56 PM
  7. Reflect TBF vacancies over 2018-2019/2019-2020 budget year
    By jennah63 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2019, 07:32 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