Excel - Live filter of list based on another column?
The Excel solution is (almost) exactly the same. UNIQUE is identical. The difference is the join:
=TEXTJOIN(", ",TRUE,FILTER($B$2:$B$7,$C$2:$C$7=$E2))
It seems these same functions in Google Sheets are available in Microsoft Excel as well:
UNIQUE
(Office 365)FILTER
(Office 365)TEXTJOIN
(2019)
=TEXTJOIN(",",TRUE,FILTER(A$2:A$7,B$2:B$7=D2))