计算每台车的每公里油耗 (10750)

 

I5{=IF(H5="","",SUM(RIGHT(LARGE(IF(B$2:B$19=H5,ROW($2:$19)*10^8+C$2:C$19),{1,2}),8)*1))

J5=IF(H5="","",SUM(RIGHT(LARGE(IF(B$2:B$10=H5,ROW($2:$10)*10^8+E$2:E$10),{1,3}),8)*{1,-1}))

K5=IFERROR(I5/J5,"")