I have the following example data.
The required output data is
the logic is,
if a certain string exists in the column2 and it also exists in column1 among some other strings, it removes that string from the column1.
I have attached the input and output data below.
Bookexampledata.xlsx (9.5 KB)