Remove duplicate with two columns

Hello everybody,

I want to remove duplicates when rows of columns 'Reçu and ‘Famille d’achat’ are identical.

if i had to do it in excel i would do it like this

It’s possible ?

Thank !


Do we need to remove the duplicates in excel?

If yes we can do like this

DtNew = Dt.DefaultView.ToTable(True)

The above expression will remove the duplicates in entire table…

If we need to remove the duplicates in perticular columns we can do like this…

DtNew = Dt.DefaultView.ToTable(True,"Col1","Col2","Col3")


1 Like

Thank it work perfectly but he drop my others columns

(i use this expression DtNew = Dt.DefaultView.ToTable(True,“Reçu”,"Famille d’achat

1 Like


If we mention the columns this will checks the duplicates in that columns…

It have to work…

Could you please attack the input file here?


1 Like

INPUT.xlsx (7.9 KB)

Result – > only row where Name = Christelle and Manoa is keep. And i want keep all column before remove duplicate

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