Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
You'll need a 3rd party add-in like PC Miler or maybe
Microsoft MapPoint to generate distances. Chip Pearson does have a workbook on his site that you can download. It calculates distance between 1200 different cities based on long/lat. http://www.cpearson.com/excel/latlong.htm HTH Jason Atlanta, GA -----Original Message----- 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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i set up a mileage allowance on excel. | Excel Discussion (Misc queries) | |||
record business mileage | New Users to Excel | |||
PDA MS OFFICE Where can I find a mileage template to download???? | Excel Discussion (Misc queries) | |||
Matching a List Containing Redundant Values | Excel Discussion (Misc queries) |