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

  • Thread starter Thread starter kinjour
  • Start date Start date
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.
 
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
 
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

How do I put words as the Y axis values? 0
Checkbox Next to Mail Message - How Do I Make It Visible? How Do I Make a Check Appear? 1
Extract specific information from the body of outlook mail to an Excel File using VBA 0
Analyzing Results of a Survey Using Option Buttons 2
How do I set up a check mark column? 2
How do i make an email-friendly survey? 2
Help with IF statement check value in multiple cells 1
Forms--Vista--2007 Excel 2

Back
Top