Find Jobs
Hire Freelancers

Combine two sheets into one (exclude duplicates)

$10-30 USD

Completed
Posted almost 7 years ago

$10-30 USD

Paid on delivery
I have a quick and simple job for someone who knows Excel =match and =vlookup formula... I know it's that but I just don't know how to do it.... basically I have a list of about 470 people in total and some of these people have not opened up an email i sent them... i only have the ones that opened the list but not the ones that didn't open...
Project ID: 13917971

About the project

92 proposals
Remote project
Active 7 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
Awarded to:
User Avatar
A proposal has not yet been provided
$10 USD in 1 day
4.9 (423 reviews)
7.1
7.1
92 freelancers are bidding on average $20 USD for this job
User Avatar
Hello Sir, My name is Jay and I am #1 Excel VBA programming expert on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story). About Me - I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I always take project to completion. 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 sample work before you consider awarding me the project. Thanks, Jay
$30 USD in 0 day
5.0 (772 reviews)
8.6
8.6
User Avatar
Hi, I can use Index and match to get the required details and conditional formatting to find the duplicates. Please send me the file to work on.
$10 USD in 0 day
5.0 (943 reviews)
8.1
8.1
User Avatar
ZERO ERROR GUARANTEED!! Please read my 200+ reviews. Hi, I can do this for you quickly and with great quality for cheap...Based in Nepal we provide quality work, and 100% satisfaction guarantee..We are not satisfied with the work until you are. Please read some of my customer reviews then contact me immediately. Thanks.
$20 USD in 1 day
4.9 (351 reviews)
7.7
7.7
User Avatar
Let's get it done in couple of hours. Experienced FREELANCER HERE to work for your project. Let's discuss more and finalize the project and cost. Feel free to ask me questions, if any. I look forward to work with you. Have a good day and stay fine :-) Sincere regards, Jubair
$25 USD in 0 day
4.9 (333 reviews)
7.8
7.8
User Avatar
Hi, I am working as a freelancer since 12 years and completed 1500 projects. I assure you 100% accuracy in the delivered work. I look forward to work with you. Please provide me an opportunity to get started and prove my skills. Thanks
$10 USD in 1 day
5.0 (195 reviews)
7.3
7.3
User Avatar
Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of excel projects (with both formulas and macros) and i've never had a single problem. If you are interested please send me the emails file and i will create this formula for you immediately. As i said i m serious freelancer and i've never took a single dollar unless my solution was perfect. Thanks, Milan
$10 USD in 0 day
5.0 (545 reviews)
7.1
7.1
User Avatar
I can do exactly what you need. I'm a computer science professional with extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to complete your project. Please have a look at some Excel projects I've done: https://www.freelancer.com.au/projects/Excel/Calculate-the-semi-deviation-each/ https://www.freelancer.com.au/projects/Excel/Recreate-online-calculator-using-Excel/ https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
$25 USD in 0 day
4.8 (195 reviews)
7.1
7.1
User Avatar
Dear Sir/Madam, I’ve read your brief and glad to discuss the project in more detailed. I am highly qualified for this project and have already done lots of similar excel projects for various clients around the globe. If you'd like to see some samples and my reliability, take a look at my freelancer portfolios. I assure you that I will go beyond your expectations, and looking forward to your respond Best regards, Priyal
$20 USD in 1 day
5.0 (196 reviews)
6.8
6.8
User Avatar
Dear abazovalex, I can start now to combine 2 spreadsheet about 470 people and their email with excel formula. I don't have any work for this time, so i can spend all my time. I have completed some excel project before, feel free to review my profile. Please give me the chance, i'm serious to work fast and accurate. Hopefully I can offer you my service and contribute to your success. Regards  Elta Marisa
$19 USD in 0 day
4.9 (307 reviews)
7.0
7.0
User Avatar
Hello. I have completed 6 similar projects and would like to provide my service on this task. Kindly refer to my previous projects at https://www.freelancer.com/projects/Data-Entry-Excel/Merge-edit-two-email-lists.html https://www.freelancer.com/projects/Merge-Spreadsheets.html https://www.freelancer.com/projects/Data-Entry-Excel/Merge-Spreadsheets-into-one-that.html https://www.freelancer.com/projects/Excel/Excel-Data-Tidy-Sorting/ https://www.freelancer.com/projects/Data-Entry/Mail-List-Cleaning/ https://www.freelancer.com/projects/Excel/Excel-worker-remove-duplicates-from/ Best regards, Hoang
$20 USD in 1 day
5.0 (162 reviews)
6.9
6.9
User Avatar
Hello I am highly interested to do your project . I am confident about the work . I believe that , I can do this work properly and in timely according to your instructions. Always determined to give you the best work . Moreover , I have a group which consist of 6 members. Eagerly waiting for your response to start the project . Many Thanks....
$25 USD in 1 day
5.0 (95 reviews)
6.6
6.6
User Avatar
Could you send me the two spreadsheets over? I can complete this in an hour and I can start right away. Thanks,
$25 USD in 1 day
4.9 (207 reviews)
6.7
6.7
User Avatar
Hi there, I believe you're absolutely right about the MATCH or VLOOKUP formula. Does your data have unique identifiers for the people or is it just their names? I could bump the "did not read" list up against the complete list and then create a column with Y/N so you could sort on if they read or not. Hopefully I can hear more and we can work together! Thanks either way for reading my proposal and best of luck, Shaun
$30 USD in 1 day
5.0 (93 reviews)
6.6
6.6
User Avatar
Dear Hiring Manager, I am very interested in your project. I am expert in Data Entry & Excel. I will provide you accurate work within your budget and time. Regards, Sadik
$30 USD in 1 day
5.0 (121 reviews)
6.3
6.3
User Avatar
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. We can discuss the budget post discussing the requirements. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. Lets discuss more online on chat. Thanks, Abhinav
$12 USD in 0 day
4.9 (165 reviews)
6.5
6.5
User Avatar
As a full-time freelancer, I have earned good reputation and a lot of positive feedback from my clients in the last few days.I am a statistical analyst, with strong background of Pure Statistics including a strong grip on statistical software including SPSS, Excel, Minitab, STATA, SAS, Mathematica, Statistica and Eviews. . Brilliant skills in Multivariate methods, Factor Analysis, Discriminant Analysis, Logistic Regression, Panel Data Analysis: Fixed Effect & Random Effect Models, ANOVA, Simple Linear Regression, Multiple Linear Regression, Non-Linear Models, Generalized Linear Models, Poisson Regression, Binary Data Analysis, Z-test, T-test, Chi-Square Test, F-test, Parametric Methods, Non Parametric Methods, Best Model Selection, Problems related to Probability, Sampling, Calculus, Economics, Mathematics and vice versa. Inspite of data analysis task, I deliver high quality content on time at an affordable price. My work is done efficiently and effectively, and I meet clients' needs.
$50 USD in 1 day
4.9 (82 reviews)
6.1
6.1
User Avatar
Hi, I am good at Excel and vba. I just checked the description and would be a pleasure to assist you on your project. Looking forward to discuss in the chat. -Chandra
$15 USD in 0 day
5.0 (67 reviews)
5.7
5.7
User Avatar
Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards
$29 USD in 2 days
4.7 (102 reviews)
6.2
6.2
User Avatar
Hi, I am CPA by qualification,having experience of more than 6 years plus years in reputed MNC worked as analyst so good understanding on research and finance ,having good knowledge in word excel and various accounting software Looking forward to work with you. Regards Pooja shah
$15 USD in 1 day
4.9 (47 reviews)
5.7
5.7
User Avatar
Hi, I'm experienced freelancer familiar with the work your project requires. If you're interested in working with me feel free to contact me. Best regards, ~mladenbiz
$25 USD in 1 day
4.9 (77 reviews)
5.7
5.7

About the client

Flag of UNITED KINGDOM
London, United Kingdom
5.0
6
Payment method verified
Member since Jun 3, 2014

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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.