•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Getting distance between two cities into spreadsheet by putting down their names
Our take
If you're tackling a university project focused on carbon footprints, streamlining your workflow is essential. Imagine being able to input city names directly into your Excel spreadsheet and automatically retrieve the distance between them. This not only saves time but also enhances accuracy in your calculations. While many online solutions come with costs, there are free options available that can simplify this task. Additionally, exploring methods to differentiate travel types can further enrich your project. Let’s discover how to make this process efficient and effective.
Hello, I am currently working on a carbon footprint Excel file for a university project. My main issue is that I would like to automatically get the distance between two points by typing them in the Excel file instead of having to look it up online and then enter it in the spreadsheet. I have looked online, but all the solutions I found cost money, and I would like something free. If there is also a way to differentiate how the travel would be, I would appreciate it as well, but the important thing for me is getting the distance.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#enterprise-level spreadsheet solutions#AI-driven spreadsheet solutions#no-code spreadsheet solutions#natural language processing for spreadsheets#generative AI for data analysis#modern spreadsheet innovations#machine learning in spreadsheet applications#digital transformation in spreadsheet software#rows.com#collaborative spreadsheet tools#cloud-based spreadsheet applications#automation in spreadsheet workflows#AI-powered spreadsheet#spreadsheet API integration#data cleaning solutions#distance#Excel