I am hopefully moving up with a promotion at work and have noticed a few things I want to change which will help out our planning.
Using Google sheets we create rotas for the jobs for the week and what operatives will be where and in what vehicles.
We update this multiple times during a day and are sometimes seeing people's names or vehicles duplicated across the rota i.e Joe Bloggs is showing as at two jobs on the same day.
What formula would allow me to create the rota but then flag up any duplicates to ensure this doesn't happen.
Much appreciated
