I have 2 seperate excel sheets. Both have a customer name, address, phone and so forth. One sheet has our current clients and the other sheet has posible prospects. I would like to check and see if any of our current clients reside on the prospect sheets so we do not need to call them. This way I can eliminate any duplicates from the sheets.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Check for duplicate entries
- Thread starter doneal
- Start date
NBVC
Well-known Member
- Joined
- Aug 31, 2005
- Messages
- 5,828
Try:
=If(Isnumber(Match(A1,Sheet2!$A$1:$A$100,0)),"Match","No Match")
Where A1 is the 1st client to match and Sheet2!A1:A100 is the list of clients in Sheet 2.
Adjust references, ranges and sheet names to suit and copy down the formula.
=If(Isnumber(Match(A1,Sheet2!$A$1:$A$100,0)),"Match","No Match")
Where A1 is the 1st client to match and Sheet2!A1:A100 is the list of clients in Sheet 2.
Adjust references, ranges and sheet names to suit and copy down the formula.
Upvote
0
