The file named Latitude.xlsx contains a formula to compute the distance between two cities using their latitude

Question:

The file named Latitude.xlsx contains a formula to compute the distance between two cities using their latitude and longitude. The file also contains the latitude and longitude of various US cities. Set up a drop-down menu so that when you select a city in cell P2 and another city in cell Q2, the distance between the cities is computed in cell Q10.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: