Excel Automation getting repeatative data

Help Studio
1

Hi

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.

image

1 Like
2

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

3

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.

Regards
Balamurugan.S

1 Like