i have one column with a bunch of dates and another column with a bunch of values... what I want to do is find all the values that occur on a specific date and concatenate them together in one cell... for example:
I'm using a UDF so I can concatenate a range for example contact(A:A) or contact(A1:A10)... this works fine but I'm having a hard time figuring out how to select the range based on the date condition... any ideas?![]()
Please Login or Register to view this content.
Bookmarks