How to Remove duplicate rows in columns and delete it


Still it’s not working


can you share the exact excel file one more time so that i can send you the code again

Again DOC-20231016-WA0016.xlsx (8.5 KB)

We can check with case id also bcz of the case id are same u can check the excel sheet for refresh



just use the below code

dt.AsEnumerable.GroupBy(Function(r) r(2).ToString).where(function(grp) not grp.Any(function(a) a(“Match Type”).ToString.trim.Equals(“Confirmed”))).Select(function(g) g.copytodatatable).toarray

for making group you need to mentioned a column which is having all the values in it

every thing is working fine

hope this helps

Can you elaborate more so can I understand clear



What did you passed in for each?


Group_List variable type would be

for each CN would be

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.