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 a few rows appear for selecting purposes. Until now result shows only with a maximum of 3 criteria, 4 gives none. All criteria are coupled as =filter(Table#;(...)*(...)*(...);"")
5 Replies
=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- It looks like it only accepts 3x *, adding criteria as + is possible but doesn't fit for me.
