Using Excel to input survey Information- How do I put checks against myself?

K

kinjour

I need to make certain cells accept only "x" and nothing else. I have no
idea why this is becoming such a difficulty.

Also, I have data sets in there own colum. I need to mark an "x" under
yes, no, or not sure. However, if I move too fast, I might put an "x"
under yes and not sure. Is there any way to check for that? This sheet
is going to get quite large, and manual rechecking will be a huge pain.
Anyone have any idea's?

Oh! I'm running Excel 2002.
 
A

Ardus Petus

Say your 3 columns (yes, no, not sure) are columns C thru E:
Use Data>Validation>Customized, with formula:
=AND(C2="X",COUNTIF($C2:$E2,"X")<2)
and drag down

HTH
 
Top