Annual Holiday Roster.xlsx


Hi,

I have holiday roster of drivers.

It has start and end week of vacation details of every driver.

in R2 driver no 277 is there for the first 5 weeks , in the week driver no 61 is there. Which is wrong. I want to display the 277 instead of 61.
If any drivers is vacation is started then it has finish in the same row.

can anyone help me out in solving this.