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