Find Jobs
Hire Freelancers

Excel formula / script to compare data of two files and fill in data in file two

$10-30 USD

Completed
Posted 7 months ago

$10-30 USD

Paid on delivery
Use population data in file 1 as the ledger, in file 2, for every city and state matching in file two, in column AC and AD, formula will check file 1 and if that city/ state is there in B and C column, then the formula will add the population from file 1, in column D, to file two, in column AB. There will be many duplicate city states in File 2, thats ok, the population still needs to be added for all of them found. For the cities/state that aren't found in file one that are in file 2, the formula or script can just put in those cells for population: "NOT FOUND in Top 1900 city file" This will be a $30 project.
Project ID: 37274173

About the project

10 proposals
Remote project
Active 7 mos 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
$0 USD in 1 day
5.0 (130 reviews)
6.4
6.4
10 freelancers are bidding on average $25 USD for this job
User Avatar
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
$50 USD in 1 day
4.9 (596 reviews)
8.5
8.5
User Avatar
Hello, Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced Excel professional with years of experience in all the tools of Excel including Visual Basic, Automation, Data Analysis, Complex Formulas, Analysis, Financial Modeling etc. To make your hiring decision easier, I can share the limited version quickly before you hire and then you can decide if this fulfills your needs or not. Lets discuss more in detail about my previous similar experience and how I am highly suitable for this project.
$20 USD in 1 day
4.8 (228 reviews)
7.3
7.3
User Avatar
Hello. I read your requirement and also check attachments i will do that. Please come on chat we will discuss more about this. I will waiting your reply.
$30 USD in 1 day
5.0 (14 reviews)
3.8
3.8
User Avatar
Hi dear client, I can start your project now with 100% accuracy and within time deadlines. Give me a chance to make a sample for free. If you like then you can hire. I understand your job description you need to Excel formula / script to compare data of two files and fill in data in file two I am a secretary and have a great experience in Microsoft Office for years. With me, the quality and the deadline of your paper are my utmost priority. I have the expertise needed to complete your project as I have skills in Excel, Data Entry, Excel VBA, Data Processing, Virtual assistance, Web Research, Web Scraping, Data Mining, and Data scraping, Convert Pdf to Word, Convert Pdf to Excel, Feel free to contact me for more details via chat. Thank you for your time. Thanks & regards Krishna.
$20 USD in 1 day
4.9 (12 reviews)
3.4
3.4
User Avatar
✅ Excel Expert Here! ✅ Hi, How are u? I have checked your proposal carefully. I understand your requirement well. I can complete your task perfectly in time. Please contact me and let's start your task right now. Thank you & Best regards!
$20 USD in 1 day
5.0 (2 reviews)
1.7
1.7
User Avatar
Hello there! My name is Souhardya and I am a skilled freelancer with 2 years of experience in Cognizant. I understand that you are looking for a freelancer to create a formula/script to compare data of two files and fill in data in file two. I believe that I am the perfect person for this job due to my skills in Data Entry, Excel and Visual Basic. I have extensive experience in data entry which makes me an ideal choice for this project as it requires thorough knowledge of database structures and formulas. Additionally, my skillset includes tools such as Excel which makes it easy for me to work on complex projects like this without any difficulty.
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I understand your need for Excel formula / script to compare data of two files and fill in data in file two. As a professional with extensive data processing, python and data entry, data mining, data processing and scraping skills, I can guarantee high accuracy and quality work within the agreed timeline. My skillset includes data entry, data mining, data processing and scraping which would be perfect for this project. I am confident that my skillset can meet all your needs for accuracy and speed while still keeping quality standards high. Please feel free to reach out if you have any questions or would like more information about me or my services.
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Orange, United States
5.0
201
Payment method verified
Member since Jan 13, 2009

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.