I want to delete the items in 2 columns if they have a same pattern in common.

I have a excel file which contains two columns, and now i need to delete the items which are same in both the columns, and also they can be same till a specific item, and also the file doesn't contain any duplicates, can anyone help me regarding this