Hi, 

I’m kindly asking for your help in setting up the correct formula for the attached spreadsheet.

You will find in column A a list of trucks identified by fleet numbers. On a daily basis new columns are added to manually input information on diesel volumes erogated (Column D = “Diesel Ltrs”) and a record of the mileage (Column E = “KM”).

I need a formula that can find and subtract the latest and penultimate KM values for each truck details entered to be calculate the fuel consumption (km per litre) on the last trip performed by the truck. You will find a manually entered calculation in column C in the attached file for the first truck.

Your help would be highly appreciated,

Many Thanks

Vito

​Hi, I’m kindly asking for your help in setting up the correct formula for the attached spreadsheet.You will find in column A a list of trucks identified by fleet numbers. On a daily basis new columns are added to manually input information on diesel volumes erogated (Column D = “Diesel Ltrs”) and a record of the mileage (Column E = “KM”). I need a formula that can find and subtract the latest and penultimate KM values for each truck details entered to be calculate the fuel consumption (km per litre) on the last trip performed by the truck. You will find a manually entered calculation in column C in the attached file for the first truck. Your help would be highly appreciated, Many ThanksVito  Read More

​