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