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
»
- VINOD G's blog
- Login or register to post comments
- 2932 reads
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.