T Tracy Oct 13, 2008 #1 Is there any way to set up in Excel to catch duplicate entries. Expamle: the same address entered in different worksheets
Is there any way to set up in Excel to catch duplicate entries. Expamle: the same address entered in different worksheets
S ShaneDevenshire Oct 13, 2008 #3 Hi, Suppose your data is in Sheet1 A1:A100 and in Sheet2 A1:A200 If you want to know which items in Sheet1 are in sheet2 enter the following formula in B1 and copy it down. =COUNTIF(Sheet2!A$1:A$200,A1) If the count is greater than 0 there is a duplicate.
Hi, Suppose your data is in Sheet1 A1:A100 and in Sheet2 A1:A200 If you want to know which items in Sheet1 are in sheet2 enter the following formula in B1 and copy it down. =COUNTIF(Sheet2!A$1:A$200,A1) If the count is greater than 0 there is a duplicate.
