I have 2 lists that need to be compared. They have the same info, but
slightly different. For instance, one of them has "Mr. Bob Smith" in one
cell. The other list just has "Bob Smith". I need to compare the 2 columns
and delete or mark the duplicates. So basically I need to compare part of
each cell in the column on the first sheet to a cell in a column in the
second sheet.