Hi,
I'm trying to make data validation more user friendly, as other will be
using and updating the worksheet, I'm using the following in the custom
validation:
"=AND(OR(AND(B3=$M$2,B3<=$M$250),AND(B3=$N$2,B3< =$N$250),AND(B3=$O$2,B3<=$O$250),AND(B3=$P$2,B3< =$P$23),AND(B3=$Q$2,B3<=$Q$23),AND(B3=$R$2,B3<=$ R$23)),COUNTIF($B$3:$E$46,B3)<2)
it works fine except that data between the numbers listed will still be
accepted. ie.. if I have 320, 321, 323, 324. in M2:M5, 322 will be
allowed to be entered. Is there a way to only have the numbers in the
list be accepted.
Regards
David
--
dgraham
------------------------------------------------------------------------
dgraham's Profile:
http://www.excelforum.com/member.php...o&userid=33138
View this thread:
http://www.excelforum.com/showthread...hreadid=529481