Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a Mileage Tracking function?
I am horizontally tracking vehicle maintenance. I have the 9th row
exclusively for mileage input. I'm having trouble locating and utilizing excel functions to track my vehicle mileage from one reference point, to current. (i.e. on 1/20/06 the odometer reads 90,233 ; and on 3/5/06 it reads 93,233) It would be simple if I had only one vehicle to track, but I have 15 others as well. Is there a conditional formula that would tell me such? or a hlookup function that i have overlooked? Please help me, thank you, *noah if you would like to see a copy of the workbook, then please email me at: |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a Mileage Tracking function?
Are you wanting mileage between two dates? How is the data organised e.g
where are the dates? And where do you want the result(s)? "noah" wrote: I am horizontally tracking vehicle maintenance. I have the 9th row exclusively for mileage input. I'm having trouble locating and utilizing excel functions to track my vehicle mileage from one reference point, to current. (i.e. on 1/20/06 the odometer reads 90,233 ; and on 3/5/06 it reads 93,233) It would be simple if I had only one vehicle to track, but I have 15 others as well. Is there a conditional formula that would tell me such? or a hlookup function that i have overlooked? Please help me, thank you, *noah if you would like to see a copy of the workbook, then please email me at: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mileage | Excel Worksheet Functions | |||
Gas Mileage | Excel Discussion (Misc queries) | |||
Gas Mileage | Excel Worksheet Functions | |||
How to insert tracking numbers into my webpage for RMA tracking | Excel Discussion (Misc queries) | |||
Mileage Calculation | Excel Worksheet Functions |