Snasui Excel Forum

Hi there
Hello everybody here
Now I come up with another issue .I want to return list base on x when select Group .

For example when I choose Group 5 it will show the list as in attached

Tks

Please try this formula in cell K4,

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW(A$2:A$8)/(INDEX($B$2:$H$8,0,MATCH(K$1,$B$1:$H$1,0))=K$2),ROWS(K$4:K4))),"")

Enter and copy down.

Thank you,it is working fine.one more in office I use M365.
could you help with M365 formula?
tks again

O365 can use:

=FILTER(A2:A8,INDEX(B2:H8,0,MATCH(K1,B1:H1,0))=K2)

Thank you