Thanks! =) Happy New Year!
"Bob Phillips" wrote:
Use a helper column with a formula. Assuming key in column A on Sheet1 and
Sheet2, then use
=IF(COUNTIF(Sheet1!A:A,A1)0,"Duplicate","")
and copy down
--
HTH
RP
(remove nothere from the email address if mailing direct)
"genoq" wrote in message
...
I have a workbook with 2 spreadsheets, each with containing a list of part
numbers. On the second spreadsheet, I want to compare lists and identify
duplicates from the first list, without changing the sorted order of
either
list. What is the easiest way to flag these duplicates on sheet 2
|