# How add one more filter?

1. ## 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...

2. ## Re: How add one more filter?

=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. ## 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

4. ## Re: How add one more filter?

Briliant my friends..

SOLVED

5. ## Re: How add one more filter?

Glad we could help & thanks for the feedback

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### 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