Navigating to Duplicates

[BobZ]

I have Excel 2000 at home and 2003 at the office, both
running on WinXP SP 2,

I and my staff have been reviewing and categorizing a
massive number of (several 100 thousand) files and listing
them in separate spreadsheets. When we're done I need to
combine the first three columns of data from each
spreadsheet into a single document. I will then sort by the
first column of the single document into numeric order.

Inevitably, quite a few documents will have been seen and
categorized by more than one person, so after I combine the
data into a single spreadsheet there will be duplicate
entries. However, it's inevitable that the dups won't always
have been categorized the same way by different people.

After I merge the separate spreadsheets into one, how can I
navigate from duplicate entry to duplicate entry so as to
eliminate the duplicates? I *don't* want to automatically
delete duplicates. The third column of the merged list will
show how the documents have been categorized, and due to
differences in judgment some entries will vary according to
reviewer. I therefore need to see the duplicate entries so I
can decide which categorization was erroneous and eliminate
it from the final product.

Is there a way to do this relatively pain free? If so, how?

Thanks very much.

 

[Yossy]

use pivot table. then copy the whole data using visible cell only into
another sheet and filter based on ur criteria (that is what u are looking
for). Often time u might want to filter and remove the totals from the all
the data and then filter again using your criteria. Use auto filter and click
custom then u can customize based on the criteria that comes up.

Good Luck!!

 

[Pete_UK]

Presumably one of your columns will be the name of the document/file
(assume A), which is unlikely to vary, so perhaps you can sort the
combined file on this column. You could then enter this formula in D2:

=IF(OR(A2=A1,A2=A3),"duplicate","")

and copy down to give the work "duplicate" based on column A entries.
You could apply a filter to column D to enable you to focus in on
those entries.

Hope this helps.

Pete