Home > Mobile >  Filter an excel range based on multiple dynamic filter conditions (with column values delimited)
Filter an excel range based on multiple dynamic filter conditions (with column values delimited)

Time:09-16

I posted a similar question: Sample

I was able to obtain the desired result based on filter conditions, but it requires helper columns (columns: J,K,L), via the formula in N3:

=FILTER(D3:H15, (IF(B3="ALL", D3:D15<>"*",D3:D15=B3)) * (L3:L15))

and column L does the magic to identify the rows with the wanted release values:

=LET(result, ISNUMBER(MATCH(J3:K15,TEXTSPLIT(B4,", "),0)), IF((FILTER(result, {1,0}) 
  FILTER(result, {0,1}))>0, TRUE, FALSE))

I am looking for a solution that wouldn't require helper columns and also for the general case where Release column can have more than two values, for example: A, C, G, F... if that is possible.

Here a link to my sample file:

enter image description here

  • Related