Duplicate Entry

T

Tracy

Is there any way to set up in Excel to catch duplicate entries.
Expamle: the same address entered in different worksheets
 
S

ShaneDevenshire

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.
 
Top