Am I missing some easy solution to my problem?

[JJ]

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

 

[Ms-Exl-Learner]

Try this.

Just enter this formula in Validation

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

Menu>>Validation>>Settings>>Validation Criteria>>Allow>>Custom>> and in
Formula paste this =COUNTIF(A:A,A1)=1

Menu>>Validation>>Error Alert>> Title enter this “Number Already Enteredâ€

Menu>>Validation>>Error Alert>> Error Message enter this “Column already
consist this No., So try some other Noâ€

If this post helps, Click Yes!

 

[Jacob Skaria]

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