Am I missing some easy solution to my problem?
 

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

Am I missing some easy solution to my problem?
 

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

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