Dear all,

I got a task as attached to find only the first and last trip of each vehicles which drove on one day

I need to have in C the first trip on each day and mark it as "X"
and then in D last trip of the same vehicle at the same day as "Y".

what formulas do i need in C and D ?

thanks for any help