mile

  1. E

    unique closest match formula

    Hello! I have 2 columns of data; <tbody> Mile number Stop sign's mile number 111 150 123 159 151 160 152 160 165 171 176 178 </tbody> I'm wanting to create a formula which would show/count the closest match of the signs to the mile number. It would look like this...
  2. R

    Calculate Miles Needed

    Good day, I am driving myself crazy with trying to figure this out. Please save me! I need a formula that will tell me how many miles are needed to be driven annually, based off of a Cents Per Mile and Driver Salary. Need help figuring out the "###" parts. Web example can be found here...
  3. B

    How to calculate costs, when you have different rates for different criteria?

    I'm looking for some help as whilst I have a basic working knowledge of excel, in my job I'm fast having to get to grips with more complex formulas. I need to work out the total cost for something, where you have a flat rate, and then an additional cost that changes depending on how much of...
  4. M

    (Seeking Code Examples) Enter Two Zips and Return Results from Webpage

    Greetings, I am looking to switch our current system of looking up mileage between 2 zip codes from Google Map's API to a DOD website (http://www.defensetravel.dod.mil/mobile/views/mileage/mileage.cfm) As you can see, it takes both zips and does a 'as the crow flies' distance and provides the...
  5. N

    Marathon pace sheet

    Hi, I need some help in this, below is my query. I'm looking at creating a sheet by which i can calculate the total time and pace for a marathon based on the time taken (pace) per mile. To illustrate this, let's say Mile 1 - 9:00 Mile 2 - 8:45 Mile 3 - 8:40 Mile 4 - 8:30 Mile 5 - 9:30 Mile 6 -...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top