+ Reply to Thread
Results 1 to 3 of 3

Disregard argument in FILTER function

  1. #1
    Registered User
    Join Date
    07-11-2008
    Location
    Oslo, Norway
    Posts
    16

    Disregard argument in FILTER function

    I am using FILTER function, where I define array and use multiple criteria that I want to use as filter for my result. Let say I use Country, Company and Year criteria to filter my data. Criteria is read from another cell where I have dropdown field with all possible values. It all works fine if I select for example Sweden, Volvo and 2021.

    I would like to be disregard one of the three criteria's that I am using. So for example if I want to see Sweden, Volvo and then to see values for all years, what do I do. I know I can change formula to just use two criteria's instead of three, however I am looking for potential easier solution. I would like to enter something like % or * in the year criteria field to give me ALL values (in other words disregard that criteria).

    Anyway to accomplish that?

  2. #2
    Forum Expert
    Join Date
    10-11-2021
    Location
    Netherlands
    MS-Off Ver
    365
    Posts
    1,386

    Re: Disregard argument in FILTER function

    Instead, you could use advanced filter. You are free to change the amount of criteria

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,924

    Re: Disregard argument in FILTER function

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. [SOLVED] Too many argument to function
    By Jeewon in forum Excel General
    Replies: 2
    Last Post: 01-29-2021, 07:58 PM
  2. Replies: 7
    Last Post: 01-07-2015, 06:29 AM
  3. [SOLVED] ByRef argument type mismatch / Passing array as a function argument
    By pzling in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-29-2012, 06:23 PM
  4. Function argument
    By fredlake in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-04-2010, 06:16 PM
  5. Argument for a Function
    By Rainmaker in forum Excel General
    Replies: 3
    Last Post: 07-25-2007, 08:03 PM
  6. [SOLVED] Function (array argument, range argument, string argument) vba
    By Witek in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-24-2005, 11:07 AM
  7. Variable as argument in filter range
    By Bert in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2005, 07:06 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