Vba list items separated by comma when conditions met

[kelly mort]

I have a table that I have names in column A then inside column G are numbers.

Column A is in range A17:A25 then G is also G17:G25.

So in cell A16, I want to get all names that have values greater than 10 in column G.

These names should be separated by comma. And if only one exists then no comma.

Also if none exists, we blank A16.

I am stacked .

I need help.

Thanks

 

[DanteAmor]

I'm glad to help you. I appreciate your kind comments.