I am using this code in data validation, which works
=(COUNTIF($E$10:$I$10,"Yes")+COUNTIF($E$10:$I$10,"training"))<=3
But I want to make sure the end user is only allowed to enter the words YES or TRAINING as well as the above, how can I do that ?
=(COUNTIF($E$10:$I$10,"Yes")+COUNTIF($E$10:$I$10,"training"))<=3
But I want to make sure the end user is only allowed to enter the words YES or TRAINING as well as the above, how can I do that ?