View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Alojz Alojz is offline
external usenet poster
 
Posts: 161
Default Questionnaire - How can I automate the selected answers?

Here's my suggestion:
Do not have english version so do not know exactly the english names of menu
items.
Think it´s called data auditing, u can find it in data menu. Go to this
menu, set criteria to: allow list, to the source box type: agree, disagree,
indifferent.
U should be done. Or, create list somewhere vertically. Then assign ur
source list to source box. U need actually one column for answering the
questions.

"Tayo" wrote:

Dear All,

I am trying to set up a questionnaire with the following conditions:

There are 3 set of rows with different questions, each question can only
have one chosen answer out of 3 possible answers.


Possible Answers
Agree Indifferent
Disagree

Question 1:
Question 2:
Question 3:

Now the issue is that for the 3 questions, you can only select 1 agree, 1
disagree and 1 indifferent as answer. In other words, you can't have more
than 1 agree, 1 disagree and 1 indifferent in each of the 3 set of questions.
Please, what is the best way to go about this?

Here is a sample for further clarification:

Possible Answers
Agree Indifferent
Disagree

Question 1: Yes
Question 2:
Yes
Question 3: Yes