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...
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...
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))),"")
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.
Briliant my friends..
SOLVED
Glad we could help & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks