salesforce.com is being used for our corporate CRM software. I have a csv
file of new data that needs to be imported into the database. They only look
for duplicates on three fields, none of which are in my import file. I have
phone number in my import file and I can export a report from salesforce.com
that have phone number. This exported report is a csv file. If I put them
both into a workbook I'd like to remove the row where the phone numbers
match.

sheet 1 contains my import list and column C has the phone numbers
sheet 2 is the exported report and column E has the phone numbers

I'd like to have the phone number from sheet 2 column E check against all
the rows of sheet 1 column C where a match is found delete that row from
sheet 1. This would give me a sheet 1 with no matching phone numbers in
sheet 2 and I can feel safe in importing sheet 1 into salesforce.com and not
getting any duplicates.

I've put a sample workbook here
http://priorityonefinancial.com/duplicate_search.xls

You can email at



Just remove the _ betwen each letter