Forum Discussion
FILTER Function - "include" parameter as string from another cell
Hi All I have a table on Worksheet A, unimaginatively named "Table1", with fields including "CODE". On Worksheet B, in cell C1, I have this formula: =FILTER(Table1,(Table1[CODE]="T1") + (Tabl...
=FILTER(Table11,BYROW(Table11[Code]=TEXTSPLIT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TRIM(A1),"Table1[CODE]=",""),"(",""),")",""),"""",""),{" + ",";"}),LAMBDA(r,OR(r))))
With this FILTER you can use e.g.
(Table1[CODE]="BBBB") + (Table1[CODE]="T1") + (Table1[CODE]="ENG002") + (Table1[CODE]="P1")
in cell A1.