hello somebody,
i would appreciated for assistance to figure out with my problem about data validation,
Assuming/with criteria :
1) The cells to validated are all in column B
2) The contain of cells to validated :
- all values is type "number" , must text length = 4 digits of number and prevent duplicate entry..
3) The first cell is B3
regards...
m.susanto
so you want from 1000 to 9999 then?
=AND(A1>=1000,A1<=9999,COUNTIF(A:A,A1)=1)
Last edited by martindwilson; 08-30-2013 at 11:17 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
it's simple & quickly....
thanks, Martin Wilson
ah i just thought someone might enter 1000.2
=AND(A1>=1000,A1<=9999,COUNTIF(A:A,A1)=1,MOD(A1,1)=0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks