DATA VALIDATION (HELP)

Sir,

i am entering data which contains A1 Chq no. and B1 amount i am entering one by one chq no and amount.

Now i need to not allow same chq no. in A1 column i am trying to use data validation (customs, countif formula).

kindly advice.

VINOD

Data validation for unique values

Hi,

As you want, example of COUNTIF function:

 1) Select desired range, for example A1:A100.

 2) In Data Validation window -> Settings tab -> Validation criteria, for Allow select Custom, for Formula enter:

 = (COUNTIF($A$1:$A$100, A1) <= 1)

 3) Press OK.

 

Best regards.