Formula for data validation for entry series number only
Formula for data validation for entry series number only
Hello Guys,
Kindly help me creating a formula for Data Validation that can enter only a series number.
Example if in cell A1 = 1000. The only data can be entered in cell A2 SHOULD BE plus 1 or 1001. The number 1002, 1003, 1004, or 1000 or 999 and others should be restricted. Even if I am going to directly entered in A3 up to A100 SHOULD BE plus 1 from the last serial number which is 1001.
Thanks in advance.
Click * below if this answer helped
Please take a moment to re-read the forum rules. Duplicate thread closed.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks