Thread: Lookup and Textjoin help
View Single Post
 
Old 08-25-2021, 04:51 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
I had assumed you didn't want repeating values in a list.
So take out the unique bit:
Code:
=TEXTJOIN(",  ",TRUE,FILTER(Sheet1!$C$2:$C$380,(Sheet1!$A$2:$A$380=A2)*(Sheet1!$B$2:$B$380=B2),"None"))
in cell C2 copied down.
Reply With Quote