Thread: What formula should I use to compare duplicate data between worksh

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

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" <genoq@discussions.microsoft.com> wrote in message
news:FF3D8B3D-AD44-422A-922D-B810940BD823@microsoft.com...
> 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

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" <genoq@discussions.microsoft.com> wrote in message
> news:FF3D8B3D-AD44-422A-922D-B810940BD823@microsoft.com...
> > 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
>
>
>

A fast way of flagging common items (duplicates, as you call it) between
Sheet2 and Sheet1 would be:

=--ISNUMBER(MATCH(A1,Sheet1!A:A,0))

1 means duplicate, 0 not.

genoq wrote:
> 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