I'm not sure how to clearly articulate my need but I'll try.
I thought I could create an IF() to identify duplicate entries and then concatenate the unique values associated with the duplicates using the IF formula. I couldn't figure it out.
Context:
Several co-workers were given the same data set, to 'check' boxes based on their ownership or shared ownership, now we're trying to combine the files and concatenate the unique values associated with the duplicate cells. Example below.
Screen shot 2013-09-16 at 10.55.24 AM.png
Bookmarks