Find Jobs
Hire Freelancers

Data Transferred Manually or Via Formula In Spreadsheet

£10-20 GBP

Completed
Posted over 10 years ago

£10-20 GBP

Paid on delivery
Hi all i'm not very good with formulas in Spreadsheets so could do with some help please, I have 2 tables, Each has information that i need but the information needs to be merged into 1 table. My first table, which i'd like to be the table I continue to use currently has 3 columns populated with data, POSTCODE, IPS & LOCATION and there are 2 Columns with no data which needs populated, LATITUDE and LONGITUDE. My second table has 3 Columns, POSTCODE, LATITUDE, LONGITUDE each column populated with the appropriate data. Table 1 & Table 2 have the POSTCODE column in common but there is a slight difference in data entered in both, I would like to be able to create formulas that check for matching postcodes between the two tables and if they match take the data that has been entered in LATITUDE & LONGITUDE of the second table and entered into the appropriate cells in Table 1. This would be time consuming if done manually as there are 2126 rows at present and growing. I look forward to hearing from yourselves. Many Thanks
Project ID: 5058972

About the project

24 proposals
Remote project
Active 10 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
Hey Ryan, this is just a formula. please share the excel sheet and get it done within an hour. thanks :-)
£10 GBP in 1 day
4.8 (151 reviews)
5.8
5.8
24 freelancers are bidding on average £16 GBP for this job
User Avatar
Hello - I am an expert techno-functional analyst having vast experience in lots of arenas of IT industry including Excel Macros. I am an Engineering Graduate with an MBA degree. If you see, I am among the niche bidders who has 0 failed projects and a high completion rate because I work till the full satisfaction of employer. Please give me an oppotuinty to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working file before you award me the project. Thanks, Jay
£12 GBP in 0 day
5.0 (550 reviews)
8.2
8.2
User Avatar
Hi dear Sir, I can do this for you... ...thanks
£17 GBP in 2 days
4.8 (153 reviews)
6.6
6.6
User Avatar
Well hi, i m serious freelancer with 100 % completion rate. I can create excel macro for you, that will do exactly as you want. This is really simple, but you said you want formula (i really suggest using macro (its faster and more reliable)) Anyway, i will create a button on spreadsheet that will run macro. This is very simple and i can create it within 1 hour. If you are interested please look at my profile and send me a spreadsheet, and i will create that macro for you. Thanks, Milan
£10 GBP in 1 day
5.0 (339 reviews)
6.6
6.6
User Avatar
Good day, I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. Here are the links for my past experiences: https://www.freelancer.com/projects/Excel/Drawing-EXCEL.html https://www.freelancer.com/projects/4848189.html https://www.freelancer.com/projects/Visual-Basic-Excel/Excel-user-form.html https://www.freelancer.com/projects/Excel/Excel-Spreadsheet-Timecard-for-work.html https://www.freelancer.com/projects/Data-Entry-Excel/Excel-Line-Restructured.html Regards.
£15 GBP in 0 day
5.0 (71 reviews)
6.0
6.0
User Avatar
Hello Sir/Mam I am a data and research specialist, with over 4 years of experience. My moto is simple: Excellence and 100% cllient satisfaction. My areas of work include - Product Uploading on most of backends Like Wordpress, Joomla (VirtueMart), Ebay, Amazon, Magento and Open cart. - Data entry in all components of Microsoft Office (spreadsheets, word processors) - Creating and maintaining databases and listings based on internet research - Basic research I deliver work efficiently and effectively, working in a professional manner. I can work collaboratively with clients to deliver an output that meets all expectations. I can also work independently, leveraging my experience to deliver a professional output. Thanks & Regards Rahul Rahangdale
£20 GBP in 1 day
4.8 (27 reviews)
4.6
4.6
User Avatar
Hello, I have read your requirements and ready to start asap. please provide spreadsheet. Regards, Vnex
£23 GBP in 2 days
4.9 (28 reviews)
3.9
3.9
User Avatar
I am a statistician working with excel vba there is now about 4 years. I am ready to start this job for you.
£12 GBP in 3 days
5.0 (3 reviews)
3.3
3.3
User Avatar
Hello, Thank you for the posting. Professional with years of Excel experience at your service. I can start immediately and complete the work ASAP. Pl check pm for details. Thanks and regards. malini
£13 GBP in 1 day
4.9 (16 reviews)
3.6
3.6
User Avatar
Dear Sir, I have done similar (more complex though) project in excel. I can assure you the desired result that you need. I have done my MBA from one of the ace institutes of India. As a new freelancer in the block, I have completed 11 projects till now and received great reviews from my employers. You can check them if you like. Just to give you an example to prove that I actually can do this job: This can be done using the VLOOKUP function of excel Thanks.
£13 GBP in 1 day
5.0 (8 reviews)
3.1
3.1
User Avatar
Hi, Can Complete this project. Will do it using formula, You can rely on me because i am serious on my work and not sitting here to waste time (both of us). you can check my previous reviews here (for fast & accurate completion of projects) http://www.freelancer.com/u/GurpreetSngh220.html Hope to hear back from you soon. Thanks & Regards, Gurpreet
£18 GBP in 2 days
5.0 (7 reviews)
3.2
3.2
User Avatar
I am Data Entry ,MS Word and MS Excel Expert. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high quality.
£12 GBP in 3 days
4.8 (10 reviews)
3.2
3.2
User Avatar
Hi I would like to bid here. You can trust me for accuracy and quality work. Looking forward to hear from you. Thanks.
£20 GBP in 4 days
4.6 (1 review)
1.6
1.6
User Avatar
I have recently used a function which should take care of this., I should be able to provide the solution in next 3 hours., Do not award the bid immediately, Send me the excel sheet(PM), I am going to send partially completed version in pdf., If you are satisfied then you can award me the bid then I can send you the complete file.
£13 GBP in 1 day
5.0 (1 review)
1.0
1.0
User Avatar
Its only 5 min work. Please send me the excel files I will revert it back right now.. Please assign me... I will make you understand ,how can you do that... Thanks, Suman
£13 GBP in 3 days
5.0 (1 review)
0.6
0.6
User Avatar
I am proficient in MS Excel, and will be able to start this project as soon as possible. Looking forward to working with you.
£18 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I'm interested in helping you I'm a profesional engineer. I graduated in 2005 from San Marcos University in my country, Perú. My speciality is Mechanic of Fluids. Thanks to my profesional degree, I have good skills in mathematics and physics fields. Also, I have good skills with spreadsheets and macro scripting. For your case, there are special functions in excel wich can compare "text strings" of diferent tables. That seems to me the less complicated solution. But for a better offer, I wish to take a look to your spreadsheets.
£23 GBP in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hy there, Kindly assign me this order as I would work on it professionally and complete it on time. Thanks in advance.
£15 GBP in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
speed and accuracy for data entry.........................................................................................................................................
£15 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am hard working person and have huge experience in data entry work. You can rely on me for error free results.
£18 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
This can easily be done by formula. And those sets of mismatch data can be displayed separately for your follow up.
£18 GBP in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Ballymena, United Kingdom
5.0
13
Payment method verified
Member since Apr 29, 2012

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.