Duplicate entries

  • Thread starter Thread starter Dino
  • Start date Start date
D

Dino

Here's the issue: I have a multi-page spreadsheet that has
ID numbers on each page. I can't combine the numbers, they
have to be on separate pages. I need to make sure that no
ID number is listed twice. How can I do this to make sure
that there are no duplicates in the entire spreadsheet?
Hopefully someone can help with this.
 
Dino, here is one option for a 1 time testing project that may or may not
suit your needs.

you can use a countif to see if the number to the left (or right or
whatever) matches a number that exists in the other list.

since you have multiple pages, I would suggest creating a new workbook just
for testing. paste all your numbers into one sheet, and in the next column
to the number, put a number or string that indicates which sheet they are
from (so you can identify them in the original workbook) then use a formula
from this page to show you where the duplicates are, if any.


http://www.cpearson.com/excel/duplicat.htm
 
Use countif, assume they are in sheet1 and 2

=COUNTIF('Sheet1'!$A$2:$A$500,'Sheet2'!A2)>0

copy down as long as needed, if you get a FALSE result it means that
particular ID number exist on the other sheet. Then reverse and do the same.
Then you can use the autofilter, custom and put the values that were found
in one sheet
and filter on them one by one, then delete the visible cells.
 
Back
Top