how to do diagonal subtratction

**legolas** · 08-06-2009, 02:56 AM

Dear all,

hope everybody is fine

I have this file attached : vehicle number, start kms and end kms

1-Is it possible to have in D3 a formula to do subtraction from c2 minus b3 ? all the way down ?

2- Can i have also in E7 and E10 an automatic subtracation between B2 and C7 ?depening on vehcile number ?

thanks for your usual help

**DonkeyOte** · 08-06-2009, 03:12 AM

Do you mean:

D3: =C2-B3
copied down

E3: =IF(A3<>A4,INDEX(B:B,MATCH(A3,A:A,0))-C3,"")
copied down

(note your font in some cells in E is set to red so you won't see results...)