Hi everyone

i want to make a rotation schedule where the number of city is greater than sales.
i have 32 cities to visit but i only have 23 sales, so 1 sales have to visit more than 1 city in a day and they have 1 holiday in a week, i'm using vlookup function but i got stuck.

Any help will be appreciated
Thanks