How to remove duplicates rows in excel

i have datatable… in that i have a duplicate rows

how to remove duplicates rows in datatable… ?

rows should be remove from the datatable

@sneha41

you can use groupby function to remove duplicates

datatable.asenumerable.group(function(r) r(“columnname”).tostring).select(function(grp) grp.first).copytodatatable

columnnames pass your columnname on which basis you want to remove the duplicates rows

when duplicate is measured on all columns:

When duplicated is measured on a column Set:

  • LINQ SequenceEqual with a columnset
  • LINQ GroupBy with more cols
    Group d by k1=d(“COLA”).toString.Trim, k2= d(“COLB”).toString.Trim into grp=Group
    *And also the DefaultView / Filter DataTable Approach

ColSet / single Col

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