Looking for a Formula to pull results from a column based on another column

[ftroxell]

I am trying to figure out a formula that will look at one column and return a value from a different column based on wether or not the first column is blank.

Here in my example;

I would like to build a list of names that have a number associated with them. Look in Column B and return the value in Column A if there is a number to the result and concatenate them together.

Column A	Column B		Result
Tom	2.5​		Tom, Chris, Olivia, Jan, Todd
John
Chris	5​
Olivia	6​
Jan	4​
Sherry
Todd	7.5​
Victor

Thanks for your assistance.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=textjoin(", ",,filter(a2:a100,b2:b100<>""))

 

[ftroxell]

Hi & welcome to MrExcel.
How about

=textjoin(", ",,filter(a2:a100,b2:b100<>""))

Perfect. Thank you so much!

 

[ftroxell]

Hi & welcome to MrExcel.
How about

=textjoin(", ",,filter(a2:a100,b2:b100<>""))

One follow up question if you don't mind. If Column B has nothing in it, how can I not give a "#CALC' error?

 

[Fluff]

Try

=textjoin(", ",,filter(a2:a100,b2:b100<>"",""))

 

[ftroxell]

Try

=textjoin(", ",,filter(a2:a100,b2:b100<>"",""))

Thanks so much.

 

[Fluff]

You're welcome & thanks for the feedback.