I have a list of equipment that has had meter readings on different dates through out the month. These are placed in three colums, Date, Equipment and Meter Readings. I am trying to make a cell show the last reading fof the month recorded for a specific piece of equipment. I can use VLOOKUP function to find the right reading for the equipment. I can also get it to find the right day of the month reading, but I cant get it to find the last day for the specific piece of equipment and showng the correct reading. Could someone tell if this is possible and what function would allow me to show this Value?
Date Equipment Mileage
01/01/2010 Car1 1000
02/01/2010 Car 2 1000
03/01/2010 Car3 1000
04/01/2010 Car1 1100
05/01/2010 Car3 1100
06/01/2010 Car1 1200
07/01/2010 Car2 1100
Equipment Milage at the end of month
Car 1 1200 Formula need to show these detals
Car 2 1100
Car 3 1100
I hope there is someone with an Idea of this as I a stuck.
Thanks
Rob
Bookmarks