Create a list of the unique identifier for each duplicate value in Google Sheets

Viewed 293
1 Answers

You can use FILTER/TEXTJOIN:

=TEXTJOIN(",",1,FILTER(B:B,A:A=D2))

enter image description here

Related