I have a collection of data in a spreadsheet that is 50,000 + lines
long for truck mileage sorted by vehicle number.
The column left of the truck number is the odometer reading when it was
fueled.
I need a formula or function that will find the first entry and last
entry for each vehicle and subtract the last mileage from the first to
give me total mileage for each vehicle.
The total lines for each vehicle varies from vehicle to vehicle.
Hope I gave enough info to figure this out.
Thanks, Mark