How to remove duplicates rows in excel

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