How to Find Duplicated rows in Excel

I have a Excel File,
I want to find duplicated rows in a Excel…
Please suggest me how to solve the solution.
Thank You…


can you share the sample input and expected output


hi @sneha41
if you want to remove duplicates you can use remove duplicates activity,
other ways please detriment your request.

I have a excel file
so many rows are there in column (City Name)
How to find the duplicated entries in that column


try this :

may its helps to you

From row In input_dt
Group row By a = row("Column Name").ToString.Trim Into grp = Group 
Where grp.Count > 1
Select grp.ToList
).SelectMany(Function(x) x).CopyToDataTable



Can u Share the Expected output

can you share a input


to find out the duplicate values count

dt1.AsEnumerable.GroupBy(function(row) row(0).tostring).Where(function(group) group.Count() > 1).Select(function(group) group.Key).toarray

to remove the dupliactes

dt1.AsEnumerable.GroupBy(Function(x) x(0).ToString).Select(Function(grp)

hope this helps

bro, what you want from the duplicates row,
ex you want to remove them ?
or you want to remove non duplicates rows ?
or adding new column and insert the duplicate status if these row is duplicate filling with yes?
please detriment your request

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