extract duplicate rows onto a separate worksheet

  • Thread starter Thread starter jr
  • Start date Start date
J

jr

use:
DATA | FILTER | ADVANCED FILTER

should be self explanatory ...
select the "unique" feature and copy to a second area (if
you like).
 
Seems self explanatory but that is an equal to unique
value - I want an equal to duplicate value
I don't want the unique values I want the duplicated
values. I want to see the error(duplicate) not the unique
value.
Thanks anyway.
 
Oops.

You can use a helper column with formulas like:

=COUNTIF($A$1:$A$999,A1)

Then you can filter on that column. Values of 1 will be unique. Greater than 1
will be duplicates.

If the first occurrence (of a duplicated value) isn't considered a duplicate,
you can change the formula to something like:

=COUNTIF($A$1:A1,A1)

Now Values of 1 will either be the unique entries or the first of the
duplicates.

Either way, apply the filter and copy the visible cells to your new sheet.

For a lot more info about working with duplicates, take a look at Chip Pearson's
site:
http://www.cpearson.com/excel/duplicat.htm
 
Back
Top