Find Jobs
Hire Freelancers

Create an Excel Script for Data Cleaning

$10-30 USD

In Progress
Posted about 8 years ago

$10-30 USD

Paid on delivery
There are two tabs of data in the Excel spreadsheet. The Dataset1 tab has columns labeled "Campaign, Ad Content, E-Commerce Conversion Rate, Transactions, Revenue" and the Dataset2 tab has columns labeled "Ad Name, Amount Spent (USD), Campaign Name" I would like a script that combines the data on both tabs so that 'Campaign' and 'Ad Content' on Dataset1 match with 'Campaign Name' and 'Ad Name' on Dataset2 and the other columns are matching accordingly.
Project ID: 10286677

About the project

20 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

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
20 freelancers are bidding on average $27 USD for this job
User Avatar
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you consider awarding me the project. Thanks, Jay
$50 USD in 0 day
5.0 (940 reviews)
9.4
9.4
User Avatar
Hi, I can confirm you that I will be able to complete your project with the highest quality and accuracy. No need to pay me anything if you are not satisfied with my work. I will be more than happy if I get the opportunity to work with you on this project. Please feel free to check my reviews here (https://www.freelancer.com/u/safiqulislam67.html). Best regards, Safiqul Islam
$30 USD in 1 day
5.0 (243 reviews)
7.3
7.3
User Avatar
Hello, I will be glad to help you with your problem. I manage excel and vba, so I'm ready to help you. Contact me by chat for better discuss your project, if you want of course. I could work as soon as you need. If you need it in next 12 hours I can fix it for you. I hope hear from you soon, Luis Romero
$15 USD in 0 day
5.0 (181 reviews)
6.1
6.1
User Avatar
hi i can compare the two sheets data and can provide consolidated cleaned data in third sheet. It will be done through a single click by yourself. I'll be providing you a code/program/vba cheers,
$17 USD in 10 days
5.0 (30 reviews)
6.1
6.1
User Avatar
Dear future employer, My name is Jesus Gonzalez, a perfect mix of experience and value for this job. I am a 2yr-experience bachelor telecommunications engineer who have worked for 8 months as an Excel data analyst. In my position (and also in UpWork, former oDesk), I constantly create, manage and optimize Excel spreadsheets requiring me to apply my knowlegde and skills on VBA programming, in order to design highly-functional macros that automate any spreadsheet manual tasks such as extracting information from different sources and transforming it into useful lists and databases, which is obviously what you are looking for this job. Also important is to mention that I am able to deliver the product to you comfortably within any agreed deadlines with the highest achievable quality. Respectfully yours, Eng. Jesus Gonzalez Canas
$25 USD in 1 day
5.0 (13 reviews)
4.4
4.4
User Avatar
Hi there, I’d like to be considered for your bid. I am a software developer with a strong background developing excel, access related applications, including excel functions,active x objects, sql server as backend, data processing. I can design and develop excel, ms access applications in quick time ensuring the final output is as per the precise requirement. Over 8 yrs I've worked in VBA technology and so I am accustomed to working with all sorts of excel, access related development. You can be sure that I will use my best skills to ensure the successful completion of the project. I highly value professionalism and hold myself strictly accountable to represent client's profile. I aim to form a long term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Vinay
$35 USD in 1 day
4.8 (11 reviews)
4.1
4.1
User Avatar
Dear Sir/ Madam I'm a professional VBA, VB and C# developer. I have 7+ years of experience in MS OFFICE and 4+ years of experience in VBA, VB and C# development. If you want your job done professionally and on time, I'm the person you're looking for. I am a very responsible, hard working with desire to bring my customers the best services. I am willing work with you immediately and delivery on time. My strongest skills: - Excel formula, report, dashboard template. - Ms office automation script includes excel, word, access. - Ms project automation, schedule task. - Ms office user form. - C# window form, window application. - parse xml, html, json. - SQLite, My SQL, SQL sever communication. - PDF template, parse pdf file. I can start working now. Hope you will give me this opportunity. I look forward to hearing from you. Thank you. Minh (Mr.) Skype: minh15.01.1991
$30 USD in 0 day
3.7 (7 reviews)
3.0
3.0
User Avatar
Hi, I am interested to do this for you, Please let me do it for you. Please let me know if there is anything needed to win this bid. I have analyse it and will provide its solution with 2 hours, But what about (missings and extras) mean exist in one sheet but not in other. Regards Reger
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
hello sir , I was done this type of task many time because i have 1 product . in this product, many client can required this type of functionality. so i will do this job very well and faster then other. waiting your reply, thanks
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Sir, I am writing in response to your advertisement for a “Create an Excel Script for Data Cleaning”. After carefully reading and realizing the requirements of the project, I feel that I am a suitable candidate for the project. We are a team of freelancer (working on various freelancing platform) and working on data entry, web search, data mining etc for over many years. I feel that I can add professionalism and accuracy to your current project. I will take direction well and complete a heavy workload under minimal supervision as well as minimum time. If you feel there is a mutual interest, I would welcome the opportunity to meet with you to learn more about your project, its requirements etc. Thank you in advance for your time and consideration. I look forward to hearing from you soon. Regards, Abdullah Al Mamun
$10 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Am a Excell data expert
$25 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 9 years of experience in this in MS office tool. Good knowledge of excel, word and powerpoint.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
candidate have good knowledge about Ms excel with and time management. I worked in BPO that time i was creating monthly reports and clearing dump and giving excellence data.
$24 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Vlookup formulae may also work
$27 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Walnut, United States
5.0
12
Payment method verified
Member since Apr 1, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.