Fetch the repeated string from excel cell

[Divyashreem (Divyashree Muddagangaiah)]

check this out:

Filter by duplicate column and copy the row in Excel

Hi, 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() Where q(“ColumnName”).Equals(p(“ColumnName”)) Select q).ToArray.Count>1 Select p).ToArray.CopyToDataTable() ----But as i said, i need to delete the row o…

and aslo you can use group by as well as mentioned below:

How do I group by one column in the datatable and take the sum?

How do I group by one column in the datatable and take the sum of another column based on this grouping. I have attached a sample file for better understanding.group and sum.xlsx (9.7 KB)