Remove Duplicates from Excel

Hi

In my excel contains 3 Columns, Each Column having duplicates
I want to Remove the duplicates from the Excel
Thank u

Hi @sudhasagar

I will convert your message to a public post, as I know there are plenty of users who like to solve these types of challenges.

I would also suggest you to provide a sample data to work with, as well as try to search for an answer on the Forum, for example here:
https://forum.uipath.com/search?q=duplicate%20value%20different%20columns

Thank u
For Forwarding my query to public post
i’m attaching my sample excel Test.xlsx (9.3 KB)

Fine
woud you like to remove the duplicates in each column or as a whole
because when i checked for whole excel there is no duplicates
Cheers @sudhasagar


The Yellow Colored are Duplicates in each column

Hi @sudhasagar,

This package is having the remove duplicates activity

or

Check this thread…

Regards
Balamurugan.S

1 Like

Please make this out


The Yellow Colored are Duplicates should be removed.

1 Like

Hi ,

Can you attach the excel. if you feel that it is confidential , send it via message…

Regards
Balamurugan.S

No, its a sample oneTest.xlsx (11.6 KB)

Hi @sudhasagar,

Check this thread. It has the example . try it your sample. It will work.

Regards
Balamurugan.S