Match criteria in table and make combinated result with comma separated

Dear,

Please help me with this issue i dont know which function to use. I have one criterria example Pizza, in one table, and friends who eat pizza, in result it needs to write Friend X, Friend Y. But if there is duplicate, not to show it. Here is example in attachment.

Many thanks whoever helps i just dont understand excel very well.

B8: =TEXTJOIN(", ",1,INDEX(LEFT(A1:A5,(B1:B5=A8)*255),0))

This should work in any Excel version which supports TEXTJOIN. Note that from your workbook, A8 contains Pizza.

I can't test previous solution because have no TEXTJOIN but think dublicate will present
For older versionof Excel additional column is must be
d2 and down

Formula:

Please Login or Register  to view this content.

b8

Formula:

Please Login or Register  to view this content.

Missed the part about duplicates. Make that

B8: =TEXTJOIN(", ",1,INDEX(LEFT(A1:A5,(B1:B5=A8)*(MATCH(A1:A5,A1:A5,0)=ROW(A1:A5)-ROW(A1)+1)*255),0))

It works GREAT both examples! Many thanks friends, such a great community!