How to compare duplicate values in sheet1 and sheet2 of excel using uipath

[ShilpiJ (Shilpi Jain)]

Hi @Henry

You may refer below post-

How to identify duplicates in excel column?

In that case, there is 2 way. Option1. Get Column A and B as Data table(dtbA) Loop at dtbA to row and assigin dtbB = dtb.select(ColumnB = row value) if dtbB has more than 2 line, that duplicate. Option2. Add countif excel formula in column C and if it is more than 2, then it duplicate. I recommend option 2 if you can add new column. Rgds, J,