excel duplicate validation

[G18241]

trying to make my mum a rota sheet where she cant duplicate peoples names on any one day, gone through the list box thing and it still wont stop her putting the same name twice

any ideas? got 2003 version

 

[whitecrook]

post the file somewhere where we can look at it.