MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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