Am I missing some easy solution to my problem?
To prevent duplicate entries use Data Validation from menu Data:
1. Highlight the range, lets say A1:A100
2. Choose the command Data, Validation
3. Under Allow choose Custom
4. Enter the following formula in the Formulas box:
=COUNTIF(A$1:A$100,A1)=1
If this post helps click Yes
---------------
Jacob Skaria
"JJ" wrote:
Hi,
I like to make a questionaire where you must rank the statements. Like:
A B
1 Value Statement
2 3 Statement 1
3 2 Statement 2
4 4 Statement 3
5 1 Statement 4
When is A2 a value (range 1,2,3,4) is chosen it can not be used in the other
fields. If the person starts to enter the data at A4 the same rule applies. I
used the IF statement but it seems that it won't work. Any one sugestions?
Thanks JJ
|