I have a tricky problem that I cannot fugired out. I have searched many excel forums but none of the suggestion seem to work for me.
See the attachment:
I have a table with an identifier in A, a Target in B, and Visit dates in C and D.
In my second table I want to list all visited Targets as a concat in one cell, when the visit matches the Identifier, and is within a defined time period. I need the list in one cell, because I want to mailmerge the data later.
So in essence, it works like a count ifs, but instead of counting, it should list the values, preferably with a "," in between.
Can you help me make this work, using VBA code or a UDF?
Thank you very much!