Hi,
If the rows you want to keep are the ones with a U, apply a filter to that
column, uncheck the U, then higlight all the filtered rows, right click on
the mouse, delete, then go to the filter and check the U

"Chance M" wrote:

Using Excel 2007, I have a two column list with over 100,000 rows.

Example:

Jane Doe U
Jane Doe
John Doe
John Doe U
John Doe
Jack Doe
Jack Doe

I want to run a dup check to make sure there is only one Jane, Jack or John
Doe, but the copy I want to stay is the one with a U behind it if there is
one (wouldn't matter which row is kept for Jack). From what I've done so far,
the dup check simply keeps whichever record is in the top row. Seems like it
should be an easy fix, but I'm lost. Please help.