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

Any suggestions?


Posted by Juan Pablo on November 15, 2001 12:28 PM

If your formula is


try with


I'm assuming the condition is in A1.

Juan Pablo