Excel Guru's need help with a formula/algorithm ?

[jase555]

ok anybody help,

need an excel formula that will allow me to randomly generate a password that has

2 alpha and 4 numeric and say for 50 users

eg

ab9234

thanks in advnce hopefully

jase

 

[div0]

*pedantic* Computers aren't very good at doing things "randomly"

Assuming its always "Letter, Letter, Number, Number, Number, Number":

I guess I'd do it something like this:

/edit - Spirt's way is better - mine had a stupid way of getting the "letter", and was effectively the same idea, just not as tidy

Hope it helps

 

[spirit]

yeah two seconds..

my way is cooler than way above too

here you go..
in column A
=ROUND(RAND()*(8999)+(1000),0)
column B
=CHAR(RAND()*(122-97)+97)
column C
=CHAR(RAND()*(90-65)+65)
(or same as B if you dont want Caps)
column D
=CONCATENATE(A1,B1,C1) (or in whatever order)

fill down to row 50

 

[div0]

Yeah my way doesnt guarantee UNIQUE passwords either - but thats easily fixed if you need it

I just threw that together right now - so I'm sure there are better ways of doing it!!

 

[jase555]

thanks