How to Find Duplicated rows in Excel

Help Studio
, ,
1

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

2

@sneha41

can you share the sample input and expected output

cheers

3

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

5

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

6

@sneha41

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

cheers…!

7

@sneha41

Can u Share the Expected output

8

@sneha41
can you share a input

9

@sneha41

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)
grp.First).copytodatatable

hope this helps

10

@sneha41
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

11

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