How can I remove duplicates with 2 criteria and cancel the one that doesn't fulfill a condition?

[Akshay07 (Akshay Suryawanshi)]

Hello @Jose_Bessa,

Please check this post.

How to get duplicate rows for specific column in a datatable

@Sunitha_Bist1 ListA=From m In((From p in dt.Select() where ( From q in dt.Select() where string.join(“,”,q.ItemArray).Equals(string.Join(“,”,p.ItemArray)) Select q).ToArray.Count>1 Select p).ToArray.CopyToDataTable).Select() Select Convert.ToString(m.Item(“Column Name”)).ToList or dt2=(From p in dt.Select() where ( From q in dt.Select() where string.join(“,”,q.ItemArray).Equals(string.Join(“,”,p.ItemArray)) Select q).ToArray.Count>1 Select p).ToArray.CopyToDataTable ListA=From p In d…