Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Random alpha generator
to have 1200 unique 2 letter combinations you need about 35 unique characters.
this normally would not be done with alphnumeric because of the similarities between 0 Zero and the letter O and 1 (one) and the letter I Combining lower case and upper case letters is a possibility. From your title is sounds as though you want to gererate them randomly rather than just assigning them. What I would to to generate them and get them into a random order is to first enter in a column (A?) a,b,c,...X,Y,Z (one letter per cell). I would fill this column with copies down to 2704. I would then copy this column to the next column (B?) and in a third Column (c?) enter in C1 =A1 & B1, and copy this cell down to C2704 In a fourth coulmn (D?) I would enter =Rand() in D1 and copy this down to D2704 then selecting Columns ABCD and sorting by Column D You would have in column C a list of 2704 unique 2 letter identifiers. Note I would select all and paste values over the top of the calculations. If you can't use the lower and upper case characters, you will need to establish what your needed unique characters are and just adjust the limits of he cells by whatever number of characters you end up with "DBuche" wrote: I need a way to generate over 1200 unique two letter combinations. I've been reading past posts that explain ways to use the MATCH and VLOOKUP functions to convert numbers to text, but have not found the solution yet. Any help would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
How do you create a random number generator in Excel? | Excel Worksheet Functions | |||
How do I find random number in list of random alpha? (Position is. | Excel Discussion (Misc queries) | |||
Random number generator | Excel Worksheet Functions | |||
Random # Generator | Excel Worksheet Functions |