Is there a mileage grinder available?
I WORK WITH DISTANCES FROM CITY TO CITYS IN THE US. ALMOST ALL ARE
REPETITIVE, BUT THE DESTINATIONS CHANGE DAILY. IS THERE A TOOL, OR WIZARD
THAT CAN CRANK THESE OUT LIKE THE FORMULA BAR? IN OTHER WORDS I GET 125
DESTINATIONS FROM ROCK ISLAND, IL, AND ANOTHER 87 DESTINATIONS FROM SHELL
ROCK, IA. THESE COME IN VIA E-MAIL IN EXCEL FORMAT, COLUMN A IS
ORIGINATION CITY, COLUMN B IS STATE ABREVIATION. COLUMN D IS DESTINATION
CITY, COLUMN E IS STATE ABREVIATION. IS THER A WAS OF READING IF A, B AND C,
D THEN FIND FIGURE FROM MILEAGE TABLE?
|