Get the most repeated value in datatable

[pattyricarte (Patty Boy)]

Hi @Chris_King_Baniqued

you can follow this link for your reference.

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…

cheers

Happy learning