joshworl10
08-21-2018, 06:46 AM
Hi,
I'm trying to delete out rows from "sheet 1" when the name in column C contains the same words as a list on "sheet 2" in column C. The issue is that the data pulled into column C on "sheet 1" changes slightly every time however the key first word or two I have recorded in "sheet 2" column C.
For example:
"sheet 1" column C could pull "John Smith asset management" or "XYZ asset managemen" or any number of small variations to the same name
"sheet 2" column C would have "John Smith"
Is there a script that could run through both columns and locate partial matches and could delete the values that have no matches at all out of the table in "sheet 1"?
Any help appreciated thx
I'm trying to delete out rows from "sheet 1" when the name in column C contains the same words as a list on "sheet 2" in column C. The issue is that the data pulled into column C on "sheet 1" changes slightly every time however the key first word or two I have recorded in "sheet 2" column C.
For example:
"sheet 1" column C could pull "John Smith asset management" or "XYZ asset managemen" or any number of small variations to the same name
"sheet 2" column C would have "John Smith"
Is there a script that could run through both columns and locate partial matches and could delete the values that have no matches at all out of the table in "sheet 1"?
Any help appreciated thx