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

Do you need to automate the process? Will you have to do this repetatively?

If not use the "MATCH() function on sheet 1 against the data on sheet 2. For
all rows were there is a match you will get a number. Sort the sheet so that
all the non numeric results are together and delete those rows.


"M.Siler" wrote in message
...
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