Hello Everyone. I've been using this forum for a while which has helped me resolve many issues and develop some decent reports. Thank you for that.
I have a situation I'd like to see if I can resolve programmatically (forumulas / functions) versus the built-in sorting, filtering, text-to-column tools. I'll have to do this each month and it's just one part of an overall monthly task.
What I need to be able to do is locate the value from a cell in Table2 and tag it with a Y or N. Then based on wether it's Y or N, concatenate the values from a column in Table1. The sheet Table2_result is what I'd like to end up with. The cells in Column2 of Table1 contain multiple values separated by a comma and space.
I was able to break this up into multiple tables via text-to-column and sorting etc to get to the end-result but it's a lot of work which I could like to automate as much as possible. If I can't automate everything I'd like to be to at least get some of done via formulas. I tried various functions and can only partially get what I want.
I'm using Excel 2010. The attached has some brief notes explaining what I need with examples. Any input would be greatly appreciated. Even if it's just suggestions on what functions might work for this I'll try to figure out how to make it work. Or other techniques.
excel forum problem sample1.xlsx
Bookmarks