
Completed
Posted
Paid on delivery
I'm working with a list of city names and their corresponding GPS coordinates in a Google Sheet. I need a formula that can scroll through the city names and find their matching GPS coordinates in another column. If multiple city names match the same GPS coordinates, I want the formula to return all matches. Ideal skills for this project include: - Proficiency in Google Sheets - Experience with creating and troubleshooting Google Sheets formulas - Ability to handle and manipulate large data sets Please note that the GPS coordinates are already formatted in the column.
Project ID: 38829940
28 proposals
Remote project
Active 1 yr ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Dear Client , With over 15 years of experience in data analysis and spreadsheet expertise, I can create a formula in Google Sheets to match city names with their corresponding GPS coordinates, even accounting for multiple matches. The solution will be efficient, easy to use, and adaptable for large datasets. Let’s discuss your requirements further to get started promptly! Best regards, Ayaz Akhtar
$10 USD in 1 day
3.9
3.9
28 freelancers are bidding on average $23 USD for this job

-------------------I CAN DO IT RIGHT AWAY-------------------- ⭐⭐EXPERT IN EXCEL/G-SHEET⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, Formulas, building an excel file, excel dashboard, pivot tables, Power BI, charts, v lookup, word, excel database, and Microsoft office at large since that is my area of expertise within your minimal budget and provide quality work within the time required, I can also provide samples of my work. Let's discuss more in the chatbox. Regards Rahul
$25 USD in 1 day
5.9
5.9

Hey i can apply the google sheet formula to return the multiple or single gps coordinate for a city I am doing these types of automation for the past 6 yrs Lets connect Thanks Vishal
$18 USD in 1 day
5.3
5.3

Hi! Greetings, Having carefully reviewed your project description, I am confident in my ability to execute this project to perfection. I possess a broad spectrum of skills, knowledge, and experience in this specific field, making me the ideal candidate to handle your project. My proficiency includes Excel, Visual Basic, Data Entry, Data Processing and Google App Engine, which positions me as the best choice for the successful completion of your project. While I am well-prepared to begin, I have a few clarifying questions. Kindly drop me a message in the chat so that we can engage in a discussion regarding the project's budget and deadline. Thank you, and I look forward to the opportunity to collaborate on your project.
$30 USD in 2 days
4.9
4.9

Hi, I read your project and I am very much interested to help with write formula that can scroll through the city names and find their matching GPS coordinates in another column. If multiple city names match the same GPS coordinates, I want the formula to return all matches. I'm an Expert in MS Excel, Google sheet, Data Entry, PDF Conversion, Processing and formatting big sets of data. please send me a message through chat to discuss this task. Kind Regards, Moustafa
$15 USD in 1 day
4.9
4.9

Leveraging my extensive experience with Google Sheets and data management, I am well-equipped to provide the solution you're seeking for your city-GPS matching project. With proficiency in creating dynamic formulas that can handle large datasets, I'll ensure that your city names are accurately matched with their corresponding GPS coordinates. In case of multiple matches, I can design the formula to return all relevant data points for comprehensive analysis. Moreover, my skills in Excel go hand in hand with Google Sheets, rendering me capable of not just creating formulas but also proficient in complex data analysis and reporting which adds value to the project further. My strong attention to detail guarantees precision and accuracy, which is vital for a project dealing with GPS coordinates as even a slight error could lead things off track. Lastly, as a highly-motivated professional, I'm committed to not just solving problems, but also enhancing data management systems. Thus, should you have any additional requirements or face any issues down the line; I'd be more than happy to offer additional support and troubleshooting. Choose me for this-project, and let's get your city-GPS matching done swiftly and effectively!
$20 USD in 1 day
4.6
4.6

Greetings, I’m Saravanan, a freelancer with experience in data entry, web scraping, lead generation, Excel, Google Script, and PDF conversion to Excel. I have successfully completed similar projects, ensuring accuracy, timely delivery, and high-quality accuracy. Whether it’s extracting data from PDFs, automating tasks with Google Script, generating leads from LinkedIn, or organizing financial data, I can deliver exactly what you need. I’m ready to start immediately and meet your deadlines. Looking forward to collaborating! Thank you, Saravanan
$25 USD in 2 days
4.3
4.3

Hi, If you are interested only in a formula-based solution, I believe the FILTER function could help in your spreadsheet. The QUERY function could also help, if you need further formatting in the resulting list. But the QUERY function would require a basic understanding of SQL formats. I can work on your spreadsheet, or a sample that is very similar to your spreadsheet if the data is sensitive and cannot be shared. Depending on the complexity of your the table of data, I'll work out a solution first with the FILTER function, and explore other possible solutions, like QUERY, if needed. Within a period of one day I could return to you a working formula. From there, you might want to add a few more functionalities, and we can work out it further for no extra cost. I hope you would consider my proposal. Please send me a message, if you wish to discuss any details further. Thanks in advance ! Best regards, Tristan
$20 USD in 1 day
3.5
3.5

Hi There, As a Google Sheets developer, I can confidently say that I possess the necessary skills and expertise to help you with your project. With my deep understanding of Excel and VBA, I can create and troubleshoot formulas like the one you need, even for large data sets. I have tackled several data manipulation projects in the past, similar to your needs, and successfully developed customized solutions that streamlined workflows for businesses – a testament to my proficiency in managing and manipulating your city-GPS data set accurately. Best Regards, Mohamed
$30 USD in 1 day
2.9
2.9

Dear, I am highly skilled in Google Sheets and experienced in creating and troubleshooting complex formulas. I can efficiently match city names with GPS coordinates, ensuring accurate results even for large datasets. I am confident in delivering a solution tailored to your needs and look forward to assisting you. Best regards, Bakhtawar
$10 USD in 1 day
1.1
1.1

I specialize in crafting efficient Google Sheets solutions for data lookup and matching tasks. For your project, I’ll create a formula that accurately matches city names to GPS coordinates, accommodating multiple matches per coordinate. With proficiency in Google Sheets and experience handling large datasets, I ensure seamless functionality and optimized performance. Let’s work together to make your data easy to manage and interpret. Best regards, Dhairya Goel
$20 USD in 7 days
0.4
0.4

With over 8 years of experience in data entry and analysis, paired with a proficient handling of Excel, I am your go-to freelancer for this project. My proficiency in Google Sheets encompasses an ability to manipulate large data sets effortlessly. I have significant experience creating and troubleshooting complex formulas, which are the precise skills needed for this project. I can create a formula that will locate and match the GPS coordinates from one column to their respective city names in another, providing you an organized list of matching results. In case multiple city names correspond to the same GPS coordinates, I can make sure all the matches are obtained, so that no data is lost. Having worked for the National Accountability Bureau, accuracy and efficiency are ingrained in me. And with my high typing speed of 89 words per minute at a 98% accuracy rate, you can trust that I'll deliver quality work within a time frame. Let's collaborate and ensure your data-driven project excels!
$20 USD in 7 days
0.0
0.0

Though I may not have a formal degree or extensive history in the tech sphere, I believe my natural affinity and dedication to working with computers makes me a worthy choice for your project. Data entry is one of my strongest suits, complemented by my ability to learn quickly and a thirst for hard work. Having handled large datasets before, I understand the sensitivity of formatting data accurately, especially when it entails GPS coordinates like this. Given the proficiency you desire in Google Sheets - I assure you I'm well-versed in it. I've worked with formulas, even fine-tuned complex ones, which might be useful for your city-GPS matching requirement. You might consider giving me an opportunity to showcase my talent and dedication to your project; after all, one doesn't need a degree to be competent - a passion to get things done coupled with an eagerness to improve is 加 inissential. To conclude, I won't undermine the expertise you might find elsewhere, but if you're seeking someone flexible, pragmatic, and genuinely passionate about working on your project, please consider me. My mettle has been hardened by life's challenges and has prepared me well. Let's prove that sometimes, a fresh perspective can yield astonishing results!
$20 USD in 7 days
0.0
0.0

I have more than 5 years of experience in this type of projects. Being a beginner in this website, I know I don't have enough proof to prove you my experience. But, you have to trust me and give me this project. I am sure you'll not be disappointed. I have already complete some project like this.
$25 USD in 7 days
0.0
0.0

I'm MAMOONA, an experienced professional in Geographic Information Systems (GIS) and Remote Sensing. I've been intricately involved in handling massive datasets, which certainly qualifies me to deal with your project. Additionally, I have a solid understanding of Excel, which could be an advantage in tackling your task using Google Sheets. Moreover, my publication record speaks to my proficiency and dedication in ensuring accurate data analysis and management. Specifically, my research paper on "Disaster Assessment of Earthquake Using GIS and Remote Sensing" underlines how meticulous approach adapts to substantive questions about geographic data. By carefully applying this same mindset to your Google Sheet, I guarantee the delivery of a comprehensive formula that'll return all matches, even in case of multiple cities sharing the same coordinate. In all honesty, what attracted me to your project is not just the technical challenge it presents but rather its potential real-world applications. As someone who's actively engaged with Geographic data for public sector organizations and played a vital role in disaster risk reduction management – I see the direct practicality of this task. Thus, my unique blend of technical prowess and real-world experience makes me tailor-made for your project.
$20 USD in 3 days
0.0
0.0

I believe I am the perfect fit for your project as I excel in manipulating large data sets and have a strong command over Google Sheets, with both Data Entry and Excel skills. My years of experience have rendered me proficient in not just handling, but efficiently organizing and outputting valuable insights from mountains of data. In particular, my expertise navigating formulas within Google Sheets will greatly assist in creating an advanced formula to find city matches and their GPS coordinates. Blending this knowledge with my knack for troubleshooting, I'm confident I can deliver a robust solution that meets all your requirements. To conclude, my excellent typing speed of about 45 words per minute ensures that the task will be completed within reasonable time without compromising accuracy. With me on board, you can trust that your data will be given the meticulous attention it deserves for a successful project completion. Let's get started on this task!
$12 USD in 7 days
0.0
0.0

Experienced in designing and troubleshooting complex formulas, such as VLOOKUP, INDEX/MATCH, and ARRAYFORMULA, to automate tasks and streamline data processes. Able to resolve formula-related issues to ensure accurate calculations and results.
$20 USD in 7 days
0.0
0.0

Respected madam/sir, Thank you for sharing the details of your project. With my expertise in Excel, Visual Basic, Data Processing, Data Entry, and Google App Engine, I am confident in my ability to deliver exceptional results tailored to your needs. To ensure I fully understand your requirements and deliver the best outcome, could we discuss a few clarifying points, including the budget and timeline? I look forward to collaborating with you. Let me know a convenient time to connect. Best regards,
$20 USD in 3 days
0.0
0.0

Hello! Ensure the right choice! It’s crucial to choose the right candidate. I’ll develop a Google Sheets formula that matches city names to GPS coordinates, leveraging a geocoding API or preloaded dataset. This solution will enable seamless conversion of city names into latitude and longitude pairs for efficient use in mapping, logistics, and data analysis tasks
$10 USD in 7 days
0.0
0.0

Dear Sir, I hope this message finds you well. I am excited to submit my proposal to develop a solution for efficiently matching city names with their corresponding GPS coordinates in your Google Sheet. Project Overview: You have a list of city names and GPS coordinates, and you're looking for a solution to scroll through the city names and find the corresponding GPS coordinates. If multiple cities match the same coordinates, you require the formula to return all matching results. Key Deliverables: A working Google Sheets formula that matches city names to GPS coordinates. Clear instructions on how to use the formula for easy integration with your existing data. Testing the formula with sample data to ensure it meets your requirements. Key Deliverables: A working Google Sheets formula that matches city names to GPS coordinates. Clear instructions on how to use the formula for easy integration with your existing data. Testing the formula with sample data to ensure it meets your requirements.
$20 USD in 1 day
0.0
0.0

Hi, i read your requirement so i am ready to start working on your project please share your data files Regards.
$22 USD in 2 days
0.0
0.0

Bouillac, France
Payment method verified
Member since Dec 6, 2016
€8-30 EUR
$10-30 USD
$30-250 USD
€8-30 EUR
$10-30 USD
$10-60 USD
₹600-1500 INR
₹100-400 INR / hour
$8-15 USD / hour
₹100-400 INR / hour
₹1500-12500 INR
₹400-750 INR / hour
$15-25 USD / hour
$250-750 USD
₹12500-37500 INR
$250-750 USD
₹1500-12500 INR
€30-250 EUR
$8-15 USD / hour
₹1500-12500 INR
₹600-1500 INR
₹100-400 INR / hour
₹12500-37500 INR
₹750-1250 INR / hour
₹750-1250 INR / hour