Creating an Inter-City Distance Matrix

An Excel file that teaches how to perform Creating an Inter-City Distance Matrix operation.

Excel Professional Creating An Inter-City Distance Matrix

County names are placed as headings. Distance values are entered in a symmetric matrix format. The shortest route is determined using formulas. Conditional formatting highlights nearby distances. Summary map links are added optionally.

Hope it is useful.