Pull results from a defined column region and list one instance of each in another cell

[halesowenmum]

Hi.

I've got a list of names in Col G from row 14 down.

Users add the name or names of the owner/s of the associated task described on that row. VBA allows the user to enter more than one name in the cell as sometimes two people are involved on a single task.

What I'd like is to have a formula in cell G5 that looks at all the names that have been selected from G14 down and list them in cell G5 with a comma between each.

This will avoid manually selecting the names and possibly missing a name off - is it possible to get a formula or some VBA to populate cell G5 as described??

Many thanks.

 

[Fluff]

What version of Xl are you using?

 

[halesowenmum]

Microsoft Office 365 Business if I look at File, Account.

 

[Fluff]

In that case try
=TEXTJOIN(",",1,G14:G20)

 

[halesowenmum]

Absolutely brilliant - thank you so much. Saves a fiddly job.

 

[Fluff]

You're welcome & thanks for the feedback