Identify if there is any duplicate values in excel column

from the description we cannot derrive a complete detail set.

assumptions:

  • identfy duplicates on the name value
  • when duplicates are found, keep the first member from the duplicates set

Assign activity
dtResult =

(From d in YourDataTableVar.AsEnumerable
Group d by k=d("name").toString.Trim into grp=Group
Select r = grp.First()).CopyToDataTable