Data Validation

  • Thread starter Thread starter BethO
  • Start date Start date
B

BethO

I would like to allow only 1 response in one of four cells. What formula
would I use to check if other cells are null?
 
Hi,

Fir text responses try

=COUNTA(A1:D1)>1

or numeric

=COUNT(A1:D1)>1

Mike
 
Sorry I didn't explain my question very well. What I really need is this.

If C8 = "x" then C9:C12 must be null

or if C9 = "x" then C8, C10:C12 must be null

or if C10 = "x" then C8:C9, C12 must be null
etc.

I have 4 cells and only 1 can contain an "X". I also need to an have error
message pop up to say "only 1 selection allowed"

Thanks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Text Formula 2
Combining Text From Cells 3
If formula and Data Validation parallely 1
Data Validation 4
Data Validation/Conditional Formating 3
Restrict choices in one drop down list by response to another 4
Data Validation on Locked Cell 2
"What-if" formula for either a manual entry and automated entry 3

Back
Top