Duplicate Entry
 

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

Duplicate Entry
 

see:

http://www.cpearson.com/excel/Duplicates.aspx


--
Gary''s Student - gsnu200806


"Tracy" wrote:

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

Duplicate Entry
 

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.

--
Thanks,
Shane Devenshire


"Tracy" wrote:

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