How to find and copy the duplicate files in excel sheet using UiPath

[aksh1yadav (AKSHAY YADAV)]

Hey @RoselinYohan

Let me know if this thread is helpful for you.

How to select therepeated row from an excel with uipath studio

hello all, in an excel, there are 10 thousand rows, each row has 10 column, and i need to check column 1, column 2 and column 3 to see whether there are repeated rows. if there are two or more(eg: n) same rows, i need to select n-1 rows out and write them in another excel sheet, so that the former excel sheet just contains distinct rows. how do i use uipath studio to do this, what activity should i use? thanks a lot.

if not Lemme know

Regards…!!
Aksh