Filter Datatable and only keep items that are duplicated in one Column

[yusuf_aziz]

Hello,

I have a massive datatable of about 20,000 rows. I neee to filter the Datatable to only keep rows that are duplicated in a specific column. (In the example below, Column 2)

The pictures below show what I am trying to achive.

Could you please suggest how to do this, given the large size of the datatable, perhaps with a Linq expression?

Many thanks in advance

[ppr (Peter)]

@yusuf_aziz
Have a Look to the Link below. Here are different scenarios showcased and identfying duplicates by 1 column is Part of IT

Linq query to identify duplicates and delete both entries

@Charmaine_Matsaudza Welcome to the forum find following starter help implementing different scenarios find duplicates by 1 key column find non duplicates by 1 key column find duplicates by 1 Key column and keep first from duplicates + non duplicates FindDupsUniquesFirstFromGroup_By1Col.xaml (8.0 KB)

[yusuf_aziz]

Many thanks, exactly what I needed!