Remove duplicates from two Excel files efficiently
The attached process prompts the user to select two (2) Excel files. It removes from the second file all the rows that can also be found in the first.
As a result, we have two (2) Excel files with unique and different rows.
Note: The process can be modified depending on the column size of the relevant excel file.
Check this article for more info on how to execute SQL queries to Excel.