Forum Discussion
Solved
Formula/Format for Multiple Category/Column Options
I have a spreadsheet with multiple questions that people can answer by putting an "x" in one of five columns. Is there a way to limit their answers, though, so that if they place an "x" in one colum...
Hi Kim-Kay
With the above example, select C3:G5 > Data (tab) > Data Validation > Allow = Custom, Formula =
=AND(C3="x",COUNTIF($C3:$G3,"x")=1)
Can we add in the requirement that the field can only be left blank, or have a lower case x, or an upper case x?