How to find Duplicated rows in Excel,,,,,,,,,,

Help Robot
,
1

I have a excel, with 100 plus rows and columns ,
so i want to find duplicated rows in excel,

Thanks,!!!

2

@sagarinavya6

Try this:

(
From row In dt
Group row By a = row("CName").ToString.Trim Into grp = Group 
Where grp.Count > 1
Select grp.ToList
).SelectMany(Function(x) x).CopyToDataTable
1 Like
3

Hi @sagarinavya6

Try this

(From row In DT.AsEnumerable()
                 Group row By Key = String.Join(",", row.ItemArray) Into Group
                 Where Group.Count() > 1
                 From row In Group
                 Select row).CopyToDataTable()

OR

DT.DefaultView.ToTable(True)

Regards,

4

@sagarinavya6

What is the subsequent action? like after finding you want only duplicates? or only non duplicates? or remove them…

cheers

6

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