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.
Bookmarks