Home > IT Answers > Microsoft Windows > Excel 2007 - allocating non-repeatable values...
Help

Question

  Asked: Jun 25 2008   4:11 PM GMT
  Asked by: Ubilkhu

Excel 2007 - allocating non-repeatable values in a set


Excel 2007, Excel functions

I am creating a questionnaire.

There is a set of 4 words and users are asked to rate each word with a value from 1 to 4. The user can not repeat any of the values between the 4 words in one set. There are many sets of 4 words and as a result, this process has to be repeated many times.
I am guessing some rules for the set of words with come into play however, I am not sure how to do this.

How can I ensure users do not repeat values within a set?

Thanks in advance.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

CREATE ANSWER
View History
Start this Answer and Earn your Knowledge Points!

By clicking "Create Answer", you can write the answer to this question that can be improved upon by your peers using the Answer Wiki.

Browse more Questions and Answers on Microsoft Windows.

Looking for relevant Microsoft Windows Whitepapers? Visit the SearchEnterpriseDesktop.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register