Duplicate Entry

  • Thread starter Thread starter Tracy
  • Start date Start date
T

Tracy

Is there any way to set up in Excel to catch duplicate entries.
Expamle: the same address entered in different worksheets
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

got #REF! with fomula PRICE() 2
Hiding Rows 5
Access Auto Matching Duplicates? 0
Merge 2 excel worksheets into one and remove duplicate entries. 1
excel seach 1
Excel Workbook with Multiple worksheets 2
Duplicate Values in Excel 2007 6
Find Duplicate data 2

Back
Top