Forum Discussion

BazzaP87's avatar
BazzaP87
Copper Contributor
Jun 17, 2025

How do i filter from a table

 

123456789

Andy

 x  x x x
Bob   x x   
Mohx x x  x 
Stuxxx   x  
Zee x   x   

 

Hi, 

I want to know if I have a table similar to this - I want to be able to filter from the names and show which categories are outstanding for that person 

 

Example - Moh - 1,3,5,8

 

Thanks for any help

excel

3 Replies

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Jun 18, 2025

    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"))))

     

  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Jun 17, 2025
    =LET(arr,LAMBDA(x,CHOOSE(x,A2:A6,SEQUENCE(ROWS(B2:H6)))),
MAP(arr({1}),arr({2}),LAMBDA(a,b,a&" - "&TEXTJOIN(", ",,FILTER(B1:J1,CHOOSEROWS(B2:J6,b)="x")))))

     

    =BYROW(SEQUENCE(ROWS(A2:A6)),LAMBDA(r,CHOOSEROWS(A2:A6,r)&" - "&TEXTJOIN(", ",,FILTER(B1:J1,CHOOSEROWS(B2:J6,r)="x"))))

    These formulas return the expected result if i correctly understand what you are looking for.

Resources