I need a way to remove duplicate leads from my lists when I import new leads on a regular basis.
Currently I'm working in excel - open to other suggestions.
I have my excel sheet with all current leads, and I'm constantly updating with new leads to market and I need to cross reference if any new leads have already been contacted.
Basically I just need to have a code function that cross references if the phone number column already exists in the current excel sheet, if it does then it deletes the entire cell line set ensuring we don't have duplicate data on board.
I'm open to using anything, software, web php, excel etc etc.
This project is for assisting me with finding and setting up a solution for my needs specified above.
Please bid accordingly.
18 freelancers are bidding on average $62 for this job
Greetings! Removing duplicates can be achieved by writing an Excel VBA macro and at the click of a button. We only need Excel for this and no other software is needed. For further details and a DEMO, please see PM.
I had developed complicated financial model in the past. Your requirement to remove the duplicated leads should be straight forward. I can't comment further until I see your spreadsheet. Look forward to work with you.