How do I limit entry into only 1 box of 10 choices available

  • Thread starter Thread starter BJ
  • Start date Start date
B

BJ

I have about 10 different options for health benefits and I want employees to
select only one out of the 10. I want them to put an X in the box to indicate
their selection. How do I prevent them entering an X into more than one box?
 
You can use validation. Select the range B1:B10. Select Data -> Validation...
-> Custom -> add the formula =COUNTA($B$1:$B$10)=1

Obviously you can change the range to suit. You can also add a meaningful
error message and such...
 
Data Validation.

Say the user must enter an X into a single cell in the block C2 thru L2.

Click on C2 and:

Data > Validation... > Settings > Custom > Formula
=COUNTA($C$2:$L$2)<2
then copy C2 to D2 thru L2
 
Thank you. This works beautifully! Just one more question: Can you have two
Validation Rules working in the same cell at the same time? Can I have this
validation and also one that forces a capital X entry only?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I migrate MBOX to PST? 2
Entry into one cell clears other cells 1
Do not allow an entry in a cell if another cell has an entry. 5
Limiting raw score entries and possible pop up message alert? 1
Combo Box that allows user entry of values not on drop-down list 1
Checkbox Next to Mail Message - How Do I Make It Visible? How Do I Make a Check Appear? 1
Multiple Choice Box 1
Windows 10 Fed up with Win 10 33

Back
Top