Remove duplicate row from 2 excel files

[Pablito (Pawel Wozniak)]

Hi @kohbc,
Welcome to the Community!
There is exact same topic about it from today:

Checking Duplicate rows depending on the condition

Hello Everyone, Can someone please help me to understand how we can remove the duplicate values depending on the 2 columns in Data Table and also need to copy those duplicate rows into separate Data Table. For Example: Data Table having the column name “Supplier/Customer Name” contains the Duplicate Data and also need to check the column “Credit LC” to make sure it is duplicate or not. Then need to copy the duplicate in a separate sheet. I have used the Remove Duplicate Rows Activity which i…