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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference last entered value in a column
This returns the last value in a range B2:B32
=INDEX(B:B,MAX(IF(B2:B32<"",ROW(2:32)))) just lengthen as required. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "nukechemtech" wrote in message ... 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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference last entered value in a column
Forgot to mention it is an array formula, so enter with Ctrl-Shift-Enter.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Bob Phillips" wrote in message ... This returns the last value in a range B2:B32 =INDEX(B:B,MAX(IF(B2:B32<"",ROW(2:32)))) just lengthen as required. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "nukechemtech" wrote in message ... 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/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference last entered value in a column
That worked great, now I just set conditional formatting to change the color of my "oil change due" mileage after comparing with the current mileage. Thanks alot! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
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) |