Data Validation - Validating TXT!!!??? :(

Galvin · Apr 20th, 2002, 11:09 AM

I want to enter a validation on a cells, the data can only be "A B or C" so how can I do that, I'm a Newb to i'm a bit confused! thank u mike

Mudface · Apr 20th, 2002, 11:24 AM

Try this:

On a separate sheet to where you want the validation to occur, type in A B and C in separate cells. Select those cells, click on Insert-Name- Define and enter a name in the top box (say myList) and click on 'Add'. Go onto the sheet where you want the data to be validated, select the cells and click on Data-Validation, change the 'Allow' to List and in the Source box enter =myList. HTH.

Yogi Anand · Apr 20th, 2002, 11:49 AM

Quote:

On 2002-04-20 10:09, Galvin wrote:
I want to enter a validation on a cells, the data can only be "A B or C" so how can I do that, I'm a Newb to i'm a bit confused! thank u mike

Hi Galvin:
In addition to what Mudface suggested, you could also use a formula for validation ...

1) Click on A1 then highlite the cells you want to validate
2)DATA|VALIDATION|SETTINGS|Allow|Custom|Formula

3) enter the following formula in the formula box

=or(A1="A",A1="B",A1="C")

HTH

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 20th, 2002, 11:09 AM	#1
Galvin New Member Join Date: Apr 2002 Posts: 1	I want to enter a validation on a cells, the data can only be "A B or C" so how can I do that, I'm a Newb to i'm a bit confused! thank u mike

Apr 20th, 2002, 11:24 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Try this: On a separate sheet to where you want the validation to occur, type in A B and C in separate cells. Select those cells, click on Insert-Name- Define and enter a name in the top box (say myList) and click on 'Add'. Go onto the sheet where you want the data to be validated, select the cells and click on Data-Validation, change the 'Allow' to List and in the Source box enter =myList. HTH.