Excel 2003. I have a dynamic sorted list of trucks in col A. Fuel purchased in B, Cost of fuel in C, and Odometer reading in D. I need a macro that will find the beginning and ending ODO readings for each truck so I can calculate the fuel mileage and cost for each.
The list is dynamic because...