Assuming you have Data Validation dropdowns with the three possible answers
to pick from

Debra Dalgleish shows how to hide an item in the dropdown once it has been
entered.

http://www.contextures.on.ca/xlDataVal03.html


Gord Dibben MS Excel MVP

On Fri, 6 Feb 2009 14:30:01 -0800, Tayo
wrote:

Hi Alojz,
Thanks for your response. Yes I know about what you are talking about (Data
Validation) but it won't solve the issue of entering same answer twice within
the 3 questions. What I mean is that somebody can now answer Agree in
qusetion 1 and answer Agree again in question 2. I don't want this. I want
to make sure that you can only select one type of answer once within the set
of 3 questions. I hope you understand my explanation.

"Alojz" wrote:

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