Getting a table and combining comments

[KColgrove]

Hello,

I'm trying to figure out how to combined strings that meet certain criteria. I have a table that holds comments from users and I want to be able to have the answers from one person and concatenate them into one cell. I included an example of what I'm trying to figure out.

Name	Greetings	Comment
Bill	Morning	Hello People
Rachel	Morning	Hi
Bill	Morning	Welcome
Bill	Afternoon	Good Bye
Susan	Afternoon	Bye

With the table above, I want to be able to grab all the rows that include: Name and Greeting with the comment associated with them. I want to be able to grab Bill and Morning with the comment that was said. It would look like:

Bill

Morning

Hello People Welcome

So It would grab Bill and Morning and combined the two comments that were said.

[KColgrove]

I figured out how to solve my problem. I ended up using VBA instead of a function. If anyone is also trying to do the same thing I have posted my code below:

Please Login or Register  to view this content.

This code find 2 variable (one of the variable changes after the first loop) and if there is a match it grabs the cell and put it into a variable and will continue to grow till the loop is finished. I reset the variable after each loop.