To remove duplicates in excel

I’m comparing two excel sheet and I want to remove the duplicates in excel2 when I was calling excel1

@Bachali

Follow below link

Thank you so much but in my case I was comparing two Excel sheets.

can you give some sample data

name.xls (10.5 KB)

consider that this excel read and stored in dt

dt=dt.DefaultView.ToTable(True,“name”,“domain”)

this will return the Distinct values from the both column name and domain

1 Like

I got it thank you so much

Man you are awesome.
But can you plz tell me, where can i learn more about Uipath Studio, its methods, activities. I have already completed my training from UiPath academy.

1 Like

Hi,
Using this can remove the duplicate rows from excel.

Regards
Balamurugan.S

Hi @balupad14,

Here to remove duplicates in some columns,I tried with remove duplicates
We don’t the range specific from starting B1,ending it depends on data
Can you suggest anything for this