Head banging with Excel
Posted by Jen on November 15, 2001 12:14 PM
Can I have multiple data validation types within the
same column? I got a great formula off this site to
not allow duplicate docket numbers, but I also want to
restrict all entries within the same column to 10
characters.
Any suggestions?
Thanks.
Posted by Juan Pablo on November 15, 2001 12:28 PM
If your formula is
=MYFORMULA
try with
=(MYFORMULA)*(LEN(A1)<=10)
I'm assuming the condition is in A1.
Juan Pablo
