Today i have this situationi have an excel file with X columns and Y rows… i want to delete the rows if an especific colum is duplicated and save it in other Excel, how can i find the duplicate column and delete that entire row?
With this i can filter the rows if the specific column are duplicated:
Where( From q In FiltNewDt.Select()
Select q).ToArray.Count>1 Select p).ToArray.CopyToDataTable()
----But as i said, i need to delete the row only if a column is duplicated, how can i do it?