How to validate data of a cell as a serial number. Please refer my attachment- there I want: if C1 has value 1 then C2 should accept value 2 only. Likewise if C5 has value 5 then cell C6 should only accept the digit 6. Thank you and hope to get solution.
I think that this is what you want.. Enter a starting value in c1 and then try to add to C2, etc...
=$c$1+row(1:1) was used as the DV formula.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Use data validation with criteria as whole number with value previous cell +1
DataValidation.png
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks