Google Sheet Formula for City-GPS Matching

已完成 已发布的 1 个月前 货到付款
已完成 货到付款

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.

Excel 数据输入 数据处理 谷歌应用引擎 Visual Basic

项目ID: #38829940

关于项目

28个方案 远程项目 活跃的1 个月前

授予:

ayazakhtar75

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 mult 更多

$10 USD 在1天内
(15条评论)
3.9

有28名威客正在参与此工作的竞标,均价$23/小时

rahulg5466

-------------------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, exce 更多

$25USD 在1天里
(87条评论)
5.9
vishal54sharma

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

$18USD 在1天里
(95条评论)
5.3
carlitanjuguna05

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 更多

$30 USD 在2天内
(10条评论)
4.9
moustafa1

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 G 更多

$15USD 在1天里
(20条评论)
4.9
saim2105

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 tha 更多

$20USD 在1天里
(18条评论)
4.6
saravananece90

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 更多

$25 USD 在2天内
(30条评论)
4.3
engrtan

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 更多

$20USD 在1天里
(6条评论)
3.5
MohmedAbdelwahab

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 更多

$30USD 在1天里
(8条评论)
2.9
bakhtawarishfaq9

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. 更多

$10USD 在1天里
(3条评论)
1.1
Dhairya6396

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 match 更多

$20 USD 在7天内
(1条评论)
0.4
shahid093

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 更多

$20 USD 在7天内
(0条评论)
0.0
somza

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 s 更多

$20 USD 在7天内
(0条评论)
0.0
mujahid1254

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 s 更多

$25 USD 在7天内
(0条评论)
0.0
mamoonasahergis

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. 更多

$20 USD 在3天内
(0条评论)
0.0
COMPUTERSSHREYA

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 pr 更多

$12 USD 在7天内
(0条评论)
0.0
aarti1210

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 更多

$20 USD 在7天内
(0条评论)
0.0
r9049015389

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 更多

$20 USD 在3天内
(0条评论)
0.0
zebene2

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 solutio 更多

$10 USD 在7天内
(0条评论)
0.0
msajjad567

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 Overvi 更多

$20USD 在1天里
(0条评论)
0.0
thefourgraphics

Hi, i read your requirement so i am ready to start working on your project please share your data files Regards.

$22 USD 在2天内
(0条评论)
0.0