How to remove a row after checking if a value in a row from an excel file exist in another excel file

how to remove a row after checking if a value in a row from an excel file exist in another excel file

Maybe you want to load both to data tables, merge them, then remove duplicates?

I have to check if any value in col 3 of excel 1 exist in col 3 of excel 2 and if exist delete that row from excel 1

I have to check if any value in col 3 of excel 1 exist in col 3 of excel 2 and if exist delete that row from excel 1