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

Try this.

Just enter this formula in Validation

Place the cursor in a1 cell and select the whole A column then click Data

MenuValidationSettingsValidation CriteriaAllowCustom and in
Formula paste this =COUNTIF(A:A,A1)=1

MenuValidationError Alert Title enter this €œNumber Already Entered€�

MenuValidationError Alert Error Message enter this €œColumn already
consist this No., So try some other No€�

If this post helps, Click Yes!

--------------------
(MS-Exl-Learner)
--------------------



"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

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