Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Extract last and next-to-last entries in a range
I must set up a spreadsheet and extract the last and next-to-last entries in
certain columns. Those values will be linked to another sheet in the workbook entitled "Summary". The columns are set up as shown below. I have a second set of columns which are from 14:00 Friday July 29 through 8:00 Saturday July 30. I know this is a lot of info, but I'm such a novice at this. Any help would be greatly appreciated! City Mile Marker Odometer 19:00 Thursday July 28 20:00 Thursday July 28 21:00 Thursday July 28 22:00 Thursday July 28 23:00 Thursday July 28 24:00 Thursday July 28 01:00 Friday July 29 02:00 Friday July 29 03:00 Friday July 29 04:00 Friday July 29 05:00 Friday July 29 06:00 Friday July 29 07:00 Friday July 29 08:00 Friday July 29 09:00 Friday July 29 10:00 Friday July 29 11:00 Friday July 29 12:00 Friday July 29 13:00 Friday July 29 |