Data Validation

[Ron512]

I have data validation set so a value can be entered in only one of the two cells. The custom formula is: =COUNTA($H$6, $H$7) < 2

How can I change the validation so a formula can be entered in both cells but still show a validation error if the formulas produce a value in both cells?

Thanks

ron

 

[tusharm]

A formula always yields a value even if it might look like the cell is empty.

One way to deal with this is to incorporate the validation into a 'downstream' step. For an example, see
Validate Mandatory Data
http://www.tushar-mehta.com/excel/newsgroups/validate_data/index.html

I have data validation set so a value can be entered in only one of the two cells. The custom formula is: =COUNTA($H$6, $H$7) < 2

How can I change the validation so a formula can be entered in both cells but still show a validation error if the formulas produce a value in both cells?

Thanks

ron

 

[Ron512]

Tushar, Thanks for the info. I’ll check it out and let you know how it goes.

ron

 

[Ron512]

Tushar,

That’s an Interesting example but I’m having trouble applying it to my situation.

Ron

 

[tusharm]

Suppose you want data in only one of B2 or C2. Then, in D2, enter the formula =IF(B2="",C2,IF(C2="",B2,"Oops!"))

Of course, it would be even nicer if you were using D2 in further calculations since the string "Oops!" should generate other equally obvious errors.

Tushar,

That’s an Interesting example but I’m having trouble applying it to my situation.

Ron