Excel Automation getting repeatative data


My requirement is i am having a excel sheet with some repeated column values . I need to move those repeated column values in one sheet and unique column in another sheet. Please find below image of sample data. In image A and C are repeated again so those A and C row values should be pasted in new sheet and remaining unique values in another sheet.


1 Like

Why not adding a “SUMIFS” function from excel? No UiPath is required.

Hi @deepak_raj,

Take a copy of the source file call ex1.xlsx. To remove duplicates check this below link.

Next Read the data from source file and ex1.xlsx and do the compare with column of A and C.


1 Like