RandomNumber Generator
You want a random shuffle of the digits 0 - 9
in A1:I1 put in the digits 0 to 9 in A2:I2 put in the formula =rand() select A1:I2 and do Data=Sort, select options and left to right then select row2 as the key. (ascending or descending - your choice) This will sort your numbers. Also, the random numbers in column 2 will be regenerated so you are ready to repeat the sort for a new random organization. -- Regards, Tom Ogilvy "Pete" wrote in message ... I want to randomly pick a number between 1000000000 and 9999999999 with a couple of options to contend with. First: I don't ever want to pick the 1234567890 and 9876543210. Second: if the number generated has any repeat numbers then I want to regect it and select another one. IE # 1123421456 would be rejected because of the repeatitive 1's. Third: After the number is set with no repeat numbers I want to seperate it into their own colums for frther minipulation. And ideas. Thanks for you help. -- Pete |
All times are GMT +1. The time now is 02:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com