troubleshooting Question

Excel: Concatenate Issue-textjoin would be perfect ....

Avatar of Tina K
Tina KFlag for United States of America asked on
Microsoft Office* concatenateMicrosoft Excel
7 Comments1 Solution115 ViewsLast Modified:
rankings.pngI have a workbook where I am trying to concatenate cells in column A based on the values in column E  Simply put... if the value in E:E = "A1" then concatenate all the corresponding names in A:A separated by commas.  Textjoin would perfect, but we have not yet graduated to Office 365/Excel 2019.  I would really love to avoid vba if at all possible, but I'm not ruling it out.    

In my example, I would like the grid in cells P5:R8 to fill automatically with the names from A:A based on the values found in column E.  All people with a ranking of A1 should appear in cell P5 separated by commas.  I've tried all sort of combinations of if and concatenate (unfortunately, concatenateif does not work on my system either)

(Note that D contains a formula assigning a number value to the word in column C, and then concatenating B and D in column E.  These columns will be hidden)
Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros