Hello Everybody I was wondering if it possible to have excel create random 8 digit numbers, with the following condition: the numbers to the left and/or right of each other can not be either the number below or above. For example: 24681357 (Good) 23579135 (Bad, because 2 and 3 are consecutives). Any suggestions? Thank in advance.
The best you can do with formulas is to create a list of random numbers and then have a column to show which ones violate the rule. In A1 put:
In B1 put:
Please Login or Register to view this content.
Copy down as far as desired. The list will change every time there is a recalc.Please Login or Register to view this content.
A macro could generate a list of numbers that all follow the rule without showing any that violate it.
Here is a file that has both methods.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks