Am I missing some easy solution to my problem?

  • Thread starter Thread starter JJ
  • Start date Start date
J

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
 
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!
 
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
 
Back
Top