Dear All,
I got a big data file contains Vehicle number (colmn A) , Start Destination (colmn B blank) and End destination (colmn c)
i need to create a formula in B just to copy value which is in C, i know it is b3=c2 but
i want same sequence to go down along unless when value in A changes and a new vehicle number starts
then the formula should repeat again and so on, as in file b13=c12
please see attached file and i hope it is made clear
thank you for your usual help
Bookmarks