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. |
#2
|
|||
|
|||
Thanks for the fast response bj. I tried your method and though it taught me
a lot it didn't solve my problem. Perhaps I didn't state it clearly. I need 1200 random two letter combinations, no numerics. Your method produced a random but repetitive list of the same two characters; AA, BB, CC. etc. Many instances of AA, BB, etc, were generated using your method. "bj" wrote: 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. |
#3
|
|||
|
|||
Mea culpa
I forgot to write down one very important step after copying column A to Column B, SORT COLUMN B Now after the steps in column C you will have unique identifiers. "DBuche" wrote: Thanks for the fast response bj. I tried your method and though it taught me a lot it didn't solve my problem. Perhaps I didn't state it clearly. I need 1200 random two letter combinations, no numerics. Your method produced a random but repetitive list of the same two characters; AA, BB, CC. etc. Many instances of AA, BB, etc, were generated using your method. "bj" wrote: 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. |
#4
|
|||
|
|||
If you get two response I apologize. I thought I had answered this before.
I made one big mistake in my suggestion You need to sort column B before going onto the steps in column C. With this added step you wont get the multiple copies of the same combo. "DBuche" wrote: Thanks for the fast response bj. I tried your method and though it taught me a lot it didn't solve my problem. Perhaps I didn't state it clearly. I need 1200 random two letter combinations, no numerics. Your method produced a random but repetitive list of the same two characters; AA, BB, CC. etc. Many instances of AA, BB, etc, were generated using your method. "bj" wrote: 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. |
Reply |
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 |