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