Help with Data Validation

Pauljj

Well-known Member
Joined
Mar 28, 2004
Messages
2,011
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 ?
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

onlyadrafter

Well-known Member
Joined
Aug 19, 2003
Messages
5,703
Platform
  1. Windows
Hello,

In E10 as DATA VALIDATION enter

=AND(OR(E10="yes",E10="training"),(COUNTIF($E$10:$I$10,"Yes")+COUNTIF($E$10:$I$10,"training"))<=3)

and copy across.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,057
Messages
5,545,753
Members
410,704
Latest member
Cobber2008
Top