Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ideas on how to restrict a entry
How can I restrict someone from typing a dash?
For example entry should be 16F not 16-F Or how can I make my COUNTIF formula to count either entry with or without dash? Thanks, Alexandra |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ideas on how to restrict a entry
Can you show us your COUNTIF formula?
-- Rick (MVP - Excel) "Alexandra" wrote in message ... How can I restrict someone from typing a dash? For example entry should be 16F not 16-F Or how can I make my COUNTIF formula to count either entry with or without dash? Thanks, Alexandra |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ideas on how to restrict a entry
Hi Alexandra
Spreadsheet cells are close to useless when it comes to rejecting entries. A testbox on a userform can do this. Try =Countif(range, "16F")+Countif(range,"16-F") HTH. Best wishes Harald "Alexandra" wrote in message ... How can I restrict someone from typing a dash? For example entry should be 16F not 16-F Or how can I make my COUNTIF formula to count either entry with or without dash? Thanks, Alexandra |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ideas on how to restrict a entry
It is =countif(a1:a200,"16F")
"Rick Rothstein" wrote: Can you show us your COUNTIF formula? -- Rick (MVP - Excel) "Alexandra" wrote in message ... How can I restrict someone from typing a dash? For example entry should be 16F not 16-F Or how can I make my COUNTIF formula to count either entry with or without dash? Thanks, Alexandra |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ideas on how to restrict a entry
Thanks it worked!
"Harald Staff" wrote: Hi Alexandra Spreadsheet cells are close to useless when it comes to rejecting entries. A testbox on a userform can do this. Try =Countif(range, "16F")+Countif(range,"16-F") HTH. Best wishes Harald "Alexandra" wrote in message ... How can I restrict someone from typing a dash? For example entry should be 16F not 16-F Or how can I make my COUNTIF formula to count either entry with or without dash? Thanks, Alexandra |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ideas on how to restrict a entry
"Alexandra" wrote in message ... Thanks it worked! Cool :-) |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ideas on how to restrict a entry
You can use Data Validation to do this. Select the cell in which a dash must not be entered. Then, go to the Data menu and choose Validation. There, select "Custom" from the Allow list and enter the following formula =ISERROR(FIND("-",A1)) Change the A1 to the cell being validated. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Thu, 28 May 2009 09:44:02 -0700, Alexandra wrote: How can I restrict someone from typing a dash? For example entry should be 16F not 16-F Or how can I make my COUNTIF formula to count either entry with or without dash? Thanks, Alexandra |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I restrict data entry to one of two columns but not both? | Excel Discussion (Misc queries) | |||
How do I restrict data entry to one of two columns | Excel Discussion (Misc queries) | |||
Restrict entry types | Excel Discussion (Misc queries) | |||
can i restrict data entry from certain columns | Excel Discussion (Misc queries) | |||
Any ideas for a more customized data entry? | Excel Worksheet Functions |