Hi,
I have created a rota with the help of the people in this forum that works great but now i want to make it so if i have the same name appear more than once in a single column it will throw up a warning box asking if i want to proceed or not (sometimes it is necessary to have the name more than once).
This is an example of the Document:
https://tinyurl.com/ROTAHELP
I have the following formula:
=COUNTIF($D:$D,D2)=1
which works but if i use the =AND or =OR formula to use more than one data validation my original data validation for these cells ceases to work?
I have tried:
=AND (Staff,COUNTIF($D:$D,D2)=1)
=OR (Staff,COUNTIF($D:$D,D2)=1)
the countif works fine but the macro i have in place which relies on the =staff data validation suddenly stops working and this is essential to block in correctly spelt names.
Can the geniuses here take a look at my attached example and advise on how i make this work please as i am pulling my hair out!
Winner gets all the internet cookies!
Bookmarks