Hi,
I have a set of data strings (in column A). Each data string may refer to another data string, where all referenced data strings are compiled in a cell beside it in column B.
Now I already have a "Refers To" column for each data string and I want to populate a third column "Referred By". This "Referred By" column should compile all the data strings that refers to the designated data string.
For example:
STRING_1 and STRING_2 "Refers To" STRING_3, so therefore STRING_3 is "Referred By" STRING_1 and STRING_2.
I'm trying to find a way to automate this such that if anything in the "Refers To" column changes, the "Referred By" column updates correspondingly. I'm also trying to have it such that if data has multiple references, that all of the info is put into a single cell.
An example of the desired output is in the attachments.
Any suggestions would be really helpful. Sorry if the description is difficult to understand.
Thank you!
Bookmarks