Forum Discussion
Function Filter
Is it possible to use more than 3 criteria in this function? I'd like to use it in wider tables (formatted as Tables) than in the examples (>8 columns) and reduce the result with 4-5 criteria so only...
=FILTER(A2:C11;(A2:A11="A")*((B2:B11="North")+(B2:B11="South"))*((C2:C11>600)+(C2:C11<400)))
This formula works with more than 3 criteria. As i don't know what your table looks like i can only suggest a solution for the attached example.
=FILTER(Tabel73;(Tabel73['#Assen]=WAARDE(DEEL(D6;4;1)))*(Tabel73[AsMerk]=S5)*(Tabel73[Montage]=AK2);"Tabel73 aanvullen...")
Tabel73 has 8 colums from which I'd like to filter on 4 criteria
I work with the Dutch version: Tabel=Table, Waarde=Value, Deel=Mid
Tabel73 has 8 colums from which I'd like to filter on 4 criteria
I work with the Dutch version: Tabel=Table, Waarde=Value, Deel=Mid
- It looks like it only accepts 3x *, adding criteria as + is possible but doesn't fit for me.
=FILTER(A2:F11;(A2:A11="A")*((B2:B11="North")+(B2:B11="South"))*((C2:C11>600)+(C2:C11<500))*(E2:E11>80)*(F2:F11="Yes")*(D2:D11>J1))
I tried with more criteria and it accepts more than 3 and ( * ) criteria.
- You are right. After I fixed a curruption in the table (contents) I previously overlooked, more than 3 criteria is no problem, also >3x *.
Thanks for your cooperation. This is one welcome function for my purpose.