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?
would I use to check if other cells are null?
M
Mike H
Hi,
Fir text responses try
=COUNTA(A1
1)>1
or numeric
=COUNT(A11)>1
Mike
Fir text responses try
=COUNTA(A1
1)>1or numeric
=COUNT(A1
1)>1Mike
B
BethO
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
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