Custom Valdation Question

M

Minitman

Greetings,

I have a set of cells that I need to restrict what the user can enter.
I need the input to be in CAPS only. And I need it to be one of two
choices: "C" or "T". Can this be done with custom validation or is
there another way?

TIA

-Minitman
 
P

Pete JM

Hi,

First Select the cells you want to apply this to then:

Go to Data > Validation then select list from the Allow menu.

Type C,T in the Source Box.

This will then only allow C & T this can be input by typing or b
selecting it from the drop down list.

Pet
 
D

Dave Peterson

You could use a list and type C,T in that box.

And the user's could use the dropdown to choose the correct value.
 
M

Minitman

Thank you all for the quick responses. That works great.

Another quick question:

In my validation drop down box, is there any way to increase the size
the text? I am having a very hard time making it out.

TIA

-Minitman
 
A

A.W.J. Ales

Minitman,

AFAIK only if you increase the size of the column the validated cell is part
from.

Second : Although data validation does what you want : mind that it's not
failsave :
The user can "overwrite" the validation if he copies another cell and paste
it in the validated cell.
The validation will be erased by this as well.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
A

A.W.J. Ales

Sorry, 1 answer isn't applicable.
I misread the question and thought you wanted to increase the size of the
box rather than the size of the text.

Second part of my reaction still holds.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
M

Minitman

Thanks again for the quick reply. The workaround will have to do
(sigh).

One other problem that I am having concerns sort order of the
validation drop down list.

Is there any way to get the list to show up in the drop down in
alphabetical order when the actual list is not in any order?

Any advice would be appreciated.

TIA

-Minitman
 
D

Dave Peterson

I think that the list has to be sorted. You could either sort it manually
(Data|Sort) or use some worksheet formulas and some extra cells.

Bob Umlas posted this:

Assume your names in column A are named "range"
In B1, array-enter:
=ROWS(range)+1-SUM((A1<=range)*1)
Fill down
This will give an index # used in the next formula
In C1, enter (not array-enter):
=INDEX(range,MATCH(ROW(),OFFSET(range,,1),0))
fill down.
Hide column B. Col C contains the sorted results.
If you NEED to have the results in B, put what I originally said to put in B
in some other column, say G (& hide it), and have column B's offset formula
(which was in C) be changed accordingly. For example, if it were G, then in
Column B enter
=INDEX(range,MATCH(ROW(),OFFSET(range,,6),0)) where the 6 is 6 collumns away
from A, or G.

It's part of this thread:
http://groups.google.com/[email protected]
 
Top