| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference last entered value in a column
I set up a vehicle gas/maintenance log with columns of DATE, MILEAGE, GALLONS to graph & calculate gas mileage, however I also track routine maintenance like oil changes, tire rotations etc. I need help with figuring out how to compare the last MILEAGE value entered with the latest oil change mileage which will turn red when a oil change is coming up. The column lenght increases each time I get gas so how do I reference the last entered mileage with the fixed oil change mileage? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I get the last entered value in a column of values | Excel Worksheet Functions | |||
| need formula: # entered in column B will transfer to column D | Excel Worksheet Functions | |||
| Number is not entered twice in a column or row | Excel Discussion (Misc queries) | |||
| Inserting current date when number entered in cell & Circular reference error? | Excel Discussion (Misc queries) | |||
| I need a chart reference if certain criteria is entered... | Excel Discussion (Misc queries) | |||
Threaded Mode
