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" 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 |
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 |
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 |
All times are GMT +1. The time now is 07:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com