I am using a formula in a Data validation as follows
=(E10="YES")*COUNTIF($E$10:$I$10),"YES")<3
This is looking at a row in columns E to I for the word YES and only allowing the word to appear 3 times.
If I want to change this to allow the word training as well, how could I do this please ??
Cheers
Paul
=(E10="YES")*COUNTIF($E$10:$I$10),"YES")<3
This is looking at a row in columns E to I for the word YES and only allowing the word to appear 3 times.
If I want to change this to allow the word training as well, how could I do this please ??
Cheers
Paul