is there anyway to have 2 conditions in data validation

right now i have a count formula that alerts with error if a duplicate
number is put in cells A1:A10

I would like to add another condition that won't allow a user to input
a number out of sequence

example ......cellsA1:A10 are the range

a user can put the number (1) into any of the cells in the range a1:a10
and can put number (2) anywhere and so on. But they can't put the
number 3 until the number 2 has been put in. They can't put 6 until 5
is input in the range.

Thanks for any solutions.


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=377184