Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I limit entry into only 1 box of 10 choices available
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I limit entry into only 1 box of 10 choices available
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... -- HTH... Jim Thomlinson "BJ" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I limit entry into only 1 box of 10 choices available
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 -- Gary''s Student - gsnu200804 "BJ" wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I limit entry into only 1 box of 10 choices available
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? "Jim Thomlinson" wrote: 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... -- HTH... Jim Thomlinson "BJ" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can you limit the data entry range in Excel? | Excel Worksheet Functions | |||
How do i put a limit on an entry in a cell? | Excel Discussion (Misc queries) | |||
Is there a way to limit the content of a cell to 5 choices? | Excel Worksheet Functions | |||
limit text entry in a range of cells | Excel Discussion (Misc queries) | |||
Nested IF limit or Open parentheses limit | Excel Discussion (Misc queries) |