Simple password generator

ckroon

Board Regular
Joined
Nov 9, 2005
Messages
60
Hey all.

I have a list in column A with 12 colors. In column B are 12 random numbers.

In another spreadsheet, I want it to randomly take a color from A and join it with a number randomly chosen from B.

Preferably A and B are set up as lookup tables so I can generate as many semi-unique passwords as I need.

Thanks!
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,118,032
Messages
5,569,764
Members
412,291
Latest member
marypolitan
Top