Concatenate multiple values

[Rick Rothstein]

super helpful...I'm attempting to do a modification of this.

I'd like to concatenate ID numbers from all related rows within the table itself. See the attachment.

Counting and Summing for all related values is in the table (see column D), but a reporting of the values themselves? Unsure how to do this. Any great ideas? Thanks.

You can use the UDF (user defined function) that I posted here to do that...

LookUp Value and Concatenate All Found Results

HOW TO INSTALL UDFs
------------------------------------
If you are new to UDFs, they are easy to install and use. To install it, simply press ALT+F11 to go into the VB editor and, once there, click Insert/Module on its menu bar, then copy/paste the code from the above linked article into the code window that just opened up. That's it.... you are done. You can now use LookUpConcat just like it was a built-in Excel function. For the question you asked, put this formula in E2 and copy it down to E11...

=LookUpConcat(B2,B$2:B$11,A$2:A$11,", ")

There are a couple of other optional parameters available for this function which do not appear to be needed for the question you asked, but you should read the above linked article to see what they are in case things change for your situation.

[mcpizzle]

You can use the UDF (user defined function) that I posted here to do that...

LookUp Value and Concatenate All Found Results

Brilliant. My first UDF. I grokked the code of Rick's a bit more than Admin's, so I started there, and it worked like a charm.