I'm looking for help with two random number problems.
1. I need to generate 750,000 alpha-numerics, 6 characters long, excluding certain letters. I have no problem generating as many random numbers as I want, using the RANDOM function, but getting down to 6 alpha-numerics without duplicates is the problem. I've generated 1.5 million random numbers and translated them to integers. I've also built a numbered table of included alpha characters. I've tried various calculations to grab 4 numbers from the larger random number and combine them with two of the letters via calculations. The result is way too many duplicates.
2. I need to generate over 10,000 records of 24 fields, with the numbers 1-24 (or letters A-X) randomly distributed through each record, with no repeats within a record and no distribution repeated within the 10,000 records.
Any suggestions will be greatly appreciated. Andy Kappy
