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!


--
ckroon
------------------------------------------------------------------------
ckroon's Profile: http://www.excelforum.com/member.php...o&userid=29163
View this thread: http://www.excelforum.com/showthread...hreadid=488865

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),FAL SE)&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)
--
Anne Murray


"ckroon" wrote:


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!


--
ckroon
------------------------------------------------------------------------
ckroon's Profile: http://www.excelforum.com/member.php...o&userid=29163
View this thread: http://www.excelforum.com/showthread...hreadid=488865

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
--
Anne Murray


"FinRazel" wrote:

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),FAL SE)&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)
--
Anne Murray


"ckroon" wrote:


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!


--
ckroon
------------------------------------------------------------------------
ckroon's Profile: http://www.excelforum.com/member.php...o&userid=29163
View this thread: http://www.excelforum.com/showthread...hreadid=488865