Thread: copy data based on column A

Dear all,
i have as attached fixed data in A and C

i need to add values in B so that

B3 = C2 all the way down based on the number in A till it changes, repeated and so on

to make the end destination of the first trip become the start destination of the one under..

thank you

Hi
I don't quite understand what you mean. Could you please add a " before" and "after" in your sheet? Thx

I'm not sure how to explain this but simply B should read same data in C but shifted down by one cell only, and when Veh changes the formula should start the same again to shift cells down and so on

thanks

Is this what you want?

works

thanks a lot