Find duplicate values in my excel column

I have a 10 entries in first name and last name in my excel sheet. I need to find whether there is duplication in both values. It means that same first name and last name should appear only once in the sheet. How can I resolve it?


You want read unique names by ignoring duplicate names right ? If yes then follow below steps.

  1. Use Read Range activity to read the data from Excel file and it will give output as DataTable. Let’s say ‘NamesDT’.

  2. And then try below expression to find unique names.

          UniqueNamesDT = NamesDT.DefaultView.ToTable(True,"FirstName","LastName")

Where UniqueNamesDT is of type DataTable.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.