M
M.Siler
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
m_s_i_l_e_r_@_p_1_f_s_._c_o_m
Just remove the _ betwen each letter
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
m_s_i_l_e_r_@_p_1_f_s_._c_o_m
Just remove the _ betwen each letter