Simple password generator

[ckroon]

Hi all.

In COlumn A I have have ten colors (red, blue etc.)
In Column B i have ten reandom numbers (12, 54 etc)
What I want is this:
On a separate sheet, it takes a random color from column A and joins it
with a random number from column B creting a pseudo-unique password
(blue54, red12) etc.

Thanks!

 

[Guest]

Here is how I did what you want to do:

1) In row1 of columnA, place a name for this column "COLORS"

2) It will not be necessary for columnB to have ten random numbers. You
can now get your password generator to work if you paste this formula:
=HLOOKUP("COLORS",$A$1:$A$11,RANDBETWEEN(2,11),FALSE)&TEXT(RANDBETWEEN(1,100),"0")

3) Fill down to get as many random passwords as you want

Notes:
If you want to extend the range of colors (i.e. 15 colors), make sure you
change all of the 11's in the formula to 16's (one more than the number you
need)

If you want a larger range of random numbers, change RANDBETWEEN(1,100) to
something bigger, like RANDBETWEEN(1,1000)

 

[Guest]

PLEASE NOTE:

The RANDBETWEEN() function will only work if you have the Analysis ToolPak
Add-In enabled. To enable, go to Tools->Add-Ins-> check Analysis ToolPak