extract duplicate rows onto a separate worksheet

[jr]

use:
DATA | FILTER | ADVANCED FILTER

should be self explanatory ...
select the "unique" feature and copy to a second area (if
you like).

 

[Dave Peterson]

But if it's not quite self-explanatory, Debra Dalgleish self-explains it at:

http://www.contextures.com/xladvfilter01.html#FilterUR

 

[mary]

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.

 

[Dave Peterson]

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