I have 2 excel files. One of the excel file (reference file) is the list of names that I want to compare with the other excel file (student list). I’ll like to remove the duplicate row from student list when the name match the reference file.
I’m beginner to this uipath. I don’t understand the equation stated in your email below.
Just to be more specify to my question, I have 2 excel files (reference list and student list). The 2 excel files have a name column.
I’m using the name in column A reference list to check again the column D student list. If duplicate is found, delete the duplicate row in student list.