I think this is a rather unique request. I am creating work order numbers. I want the numbers to be random (so numbers can't be gathered in advance) and also unique. I would also only like the number to generate when the cell is entered. The numbers can be any 6 digit number.
Welcome to the forum.
"Random" and "unique" are mutually exclusive. Generating a unque six-digit number would require access to all previously generated numbers.
Entia non sunt multiplicanda sine necessitate
Can I approach it from this angle? Create a list of numbers to pick from. Say 1 to 3000. Once a number is selected, delete it from list
Put this in your sheet module:
Please Login or Register to view this content.
Last edited by Whizbang; 11-21-2011 at 06:05 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks