How to compare two excel sheets and remove the duplicates but keep the exceptions in sheet1 using Studio X

I have an excel workbook with two worksheets with data that I need to compare. I want to find if the values in sheet1 exist in sheet2 if so, I would like those data rows deleted from sheet1. Since I am using StudioX there is no read range activity. So I am not sure which activities to use.

1 Like

Hey @Valerie_P_Pischer

Check this out - Excel Automation