Hello!
I have two columns. Column A has a number, then a "/" and then a name:
"
123456 / John Doe
23442343 / Test Name
6323432 / Clara Test
"
Column B has just names:
"
Jason Doe
John Doe
Marc Test
"
Now, I want to delete all rows in column A which contain names from column B.
In this case I would want column A, to look like this:
"
23442343 / Test Name
6323432 / Clara Test
"
How would you do this?
Thank you very much!
Bookmarks