Instruction Only - How to Merge, Remove Two Different Data Sets

$10-30 USD

Completed

Posted

over 5 years ago

$10-30 USD

Paid on delivery

I have some work, in an Excel spreadsheet... I'm limited to a i3 processor with 8gb RAM. I only have Excel 2010... I need to do the following: One database is approx. 850k rows of two columns of data. Email Address and State. I'm in the US. I need to match that against a suppression list of just email addresses, which amount to 80k approx. What I need is clear instruction, perhaps a written vlookup formula that would see if 80k email addresses also are in the large database and remove them, with those blank rows replaced. Your written instructions for me can be in Word. Thanks .. need this right away.

Data Processing

Excel

Project ID: 17982283

About the project

10 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@egafiori

My name is Esteban, I'm Industrial Engineer and Excel/VBA Expert. I'm new freelance,You can see some of my experiences in my profile. I could also help in economic analysis and evaluations, based on regression studies and statistical estimates. I would love to help you in your project and that you can help me earn more points!!

$10 USD in 1 day

5.0

(6 reviews)

2.2

@paulodayto08

Hi Good Day! I can help you to complete your Excel works in less than a day. Can you give a sample file so I can give you a clear instruction with screenshots. I am a vba macro developer for over 8 years now and has strong knowledge with Ms Excel Formulas and Functions. I created different template and tools for financial reports. I am also a Project Management Analyst that focused in Financial and Metrics report and analyzation. Feel free to message me to discuss more about this project. Hope you will consider me to this project, I'll promise to give you the high quality of work. You can check my portfolio for some of my previous project in Ms Excel Macro Thank you!

$20 USD in 0 day

5.0

(13 reviews)

3.3

10 freelancers are bidding on average $25 USD for this job

@asifdwan

Hi there! I've read the project details and ready to start it right away. I'm an expert in data entry and data scraping jobs. I've huge experience in working on this type projects. Look forward to hearing from you. Regards

$30 USD in 0 day

4.9

(200 reviews)

7.0

@polarjin2017

Hello? How are you? I have good skills in So I can complete your job in time. Hope to work with you. Thank you.

$55 USD in 3 days

4.8

(55 reviews)

6.2

@binaryromel

Hi there, I'm expert in Advance Excel, Formula, Function and Macro. I can do this. Please check my feedback as I've done several Excel project on freelancer. Please PM me. Thank you, MOHIUDDIN.

$15 USD in 1 day