How to delete the duplicates


HI @arivu96

dt.AsEnumerable().Distinct(DataRowComparer.Default).CopyToDatatable() is to remove the duplicated data row
in my case in one column i have policy no : whether if its duplicated i should remove the row from excel

please help me


Hi Ramesh,
based on one column you need to remove the duplicate right?



yes, i have column header as APNO

also pls suggest me the solution if in case header is not there



Refer the below link

If you want specific Column alone mention the column name