Excel experts

[NYCpal]

How to make a list of duplicate records in a large dataset.

[workless_barber]

4 minutes ago, NYCpal said:

How to make a list of duplicate records in a large dataset.

first select the few rows you want to duplicate

define a name by right click selection

in different the cell give =(defined name)

[NYCpal]

1 minute ago, workless_barber said:

first select the few rows you want to duplicate

define a name by right click selection

in different the cell give =(defined name)

I wanted to make a list of duplicate records already exists in the dataset 

[workless_barber]

17 minutes ago, NYCpal said:

I wanted to make a list of duplicate records already exists in the dataset 

concatinate all the columns data in to new column and take sub total

if any subtotal is greater than 1 that is duplicate