To remove duplicates in excel


#1

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


#2

@Bachali

Follow below link


#3

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


#4

can you give some sample data


#5

name.xls (10.5 KB)


#6

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


#7

I got it thank you so much


#8

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.