+ Reply to Thread
Results 1 to 5 of 5

How add one more filter?

  1. #1
    Forum Contributor
    Join Date
    10-18-2017
    Location
    london
    MS-Off Ver
    2007
    Posts
    152

    How add one more filter?

    Hi my friends..


    My file garden filter.xlsx filter between two dates, and i want to ad one filter : garden in L3
    All my effort not work for this formula

    any ideea?


    thanks...
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: How add one more filter?

    How about this non-array formula
    =IFERROR(INDEX(A$2:A$38,AGGREGATE(15,6,(ROW(A$2:A$38)-ROW(A$2)+1)/(($A$2:$A$38>$L$1)*($A$2:$A$38<$L$2)*($C$2:$C$38=$L$3)),ROWS($A$2:$A2))),"")

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: How add one more filter?

    Change the formula in F2 to this:

    =IFERROR(INDEX($A$2:$D$38,SMALL(IF(($A$2:$A$38<$L$2)*($A$2:$A$38>$L$1)*($C$2:$C$38=$L$3),MATCH(ROW($A$2:$A$38),ROW($A$2:$A$38)),""),ROW(A1)),COLUMN(A1)), "")

    then commit using Ctrl-Shift-Enter (CSE) instead of the usual Enter, as it is an array formula.

    Then you can copy across and down. You will need to format column I as General.

    Hope this helps.

    Pete

    EDIT: Please note that if you are still using Excel 2007, as your profile states, then you won't be able to use Fluff's formula with AGGREGATE, as it was not available in that version. If you are using a later version, then please update your profile accordingly.

    Pete
    Last edited by Pete_UK; 10-07-2019 at 09:12 AM.

  4. #4
    Forum Contributor
    Join Date
    10-18-2017
    Location
    london
    MS-Off Ver
    2007
    Posts
    152

    Re: How add one more filter?

    Briliant my friends..

    SOLVED

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: How add one more filter?

    Glad we could help & thanks for the feedback

+ 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. Inserting filter into pivot table via macro errors if filter doesn't exist.
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2018, 10:24 AM
  2. Replies: 0
    Last Post: 08-04-2017, 02:39 AM
  3. VBA Advanced Filter - Two Filters Without Deleting Bottom Filter Data In Same Column Range
    By hysterical.useless in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-14-2017, 02:54 PM
  4. Macro to filter a pivot whilst looping through filter criteria in a variable list.
    By Alistairm88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-29-2015, 04:25 AM
  5. [SOLVED] Excel 2007-Adv Filter Copy and Loop with Nested Autofilter Using Values from Adv Filter
    By Southfish in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-17-2014, 02:07 AM
  6. Replies: 6
    Last Post: 10-16-2014, 08:42 AM
  7. Need to filter a report filter based on the previous filter
    By elliotencore in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-28-2014, 07:44 AM

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