Re: Navigating to Duplicates
- From: Pete_UK <pashurst@xxxxxxxxxxx>
- Date: Thu, 8 May 2008 06:23:18 -0700 (PDT)
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
On May 8, 12:32 pm, B...@xxxxxxx wrote:
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.
.
- References:
- Navigating to Duplicates
- From: BobZ
- Navigating to Duplicates
- Prev by Date: RE: Navigating to Duplicates
- Next by Date: RE: Extract rows from workbooks
- Previous by thread: RE: Navigating to Duplicates
- Next by thread: Drop down list question
- Index(es):
Relevant Pages
|
