Find all the cells that equal x and put names in another cell separated by comma

Hi

I have a long list (100+ rows) of names (Col A) and countries (Col B) and in Col C I want to list the names of people from the same country separated by a comma (see example in attachment). What is the best way to go about this?

Hi Michelle,

Here is a simple little macro which should do what you want.

Please Login or Register  to view this content.

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Hi David

That works perfectly. Thank you for your help.