Finding the Distance Between Two Provinces

An Excel file that teaches how to perform Finding the Distance Between Two Provinces operation.

Excel Spreadsheet for Finding the Distance Between Two Provinces

The latitude and longitude values of the provinces are recorded in the table. Kilometers are calculated using the Haversine formula. Route differences are indicated by colors. User entries are restricted by a validation list. The result cell is dynamically updated.

Hope it is useful.