Today, Excel is offering all sorts of support for Geography, from 3D Map, Filled Map, Geography Data Type, and Location Data Types. But there was a secret project way back in 2005 that dabbled in Geography. In this entry for Excel Hash 2021, see how Sam Rad experimented with a function to identify cities along the I-7 corridor (Bakersfield California to Stockton California).
While the functions for the remaining interstates were never completed, you could use LAMBDA, or Power Query Custom Data Types, or FILTER to build your own.
This is my entry in the 2021 Excel Hash competition. Check out other entries here:
This playlist works on a PC:
https://www.youtube.com/playlist?list=PLHrPHBbDHgT1OUshE6AFf5AJqJdhKhJh_
This playlist works on mobile:
https://youtube.com/watch?v=bCyJo3Z7aog&list=PLHrPHBbDHgT1OUshE6AFf5AJqJdhKhJh_

Check out John MacDougall’s database of the 17 competitors and vote here: http://bit.ly/ExcelVotingTool

Thanks to Rob Collie who allowed us to talk about Interstate 7 before his Raw Data Podcast. Listen to episodes here: https://powerpivotpro.com/rawdatapodcast/