Forum Discussion
How do i filter from a table
1 2 3 4 5 6 7 8 9 Andy x x x x Bob x x Moh x x x x Stu x x x x Zee x x ...
If you want result by selecting name then could try nested FILTER() function like- (see the attached file).
=TEXTJOIN(", ",1,FILTER(B1:J1,FILTER(B2:J6,A2:A6=O1)="x"))If you want result row wise then could try-
=BYROW(A2:J6,LAMBDA(r,TEXTJOIN(", ",1,TAKE(r,,1),FILTER(B1:J1,DROP(r,,1)="x"))))