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:
Data:
dates values
12/01/01 1
12/01/01 2
12/01/02 3
12/01/03 4
12/01/03 5
Results:
dates values
12/01/01 1,2
12/01/02 3
12/01/03 4,5
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?
Bookmarks