In my Workbook are two sheets, A and B. In Sheet A are in each row the Names and email Addresses and group names. For example, I want all the email Addresses for Group Apple in Sheet B, textjoined and separated by Comma.
If in Sheet B the group name matches the group name in Sheet A, take the email address and concatenate it into one string and put it in Column C of sheet B.
I used this formula
but the string of email addresses does not stop when the group name does not match anymore.
I appended an sample Workbook.
Bookmarks