My Random Password Generator

MTBer,

thank you for the link
just curious: why use 26 cells if it can be done with one formula ?
=IF(RAND()>52/62,CHAR(INT(RAND()*10+48)),CHAR(INT(RAND()*26+65)+INT(RAND()*2)*32))
this is the longest formula: generating numbers, or lcase or ucase letters: so 62 possible characters randomly choosen


Erik
EDIT: changed formula (57-48+1) ==> 10, etcetera (I pasted from the wrong post)

Here's a single cell formula that generates a lower case letter 26/62 of the time.
an upper case letter 26/62 of the time,
and a number 10/62 of the time.

63 because 26 letters plus 26 letters + 10 numbers = 62. You could adjust the probability of each to suit your needs.

Concatenate for as many characters as desired.

Note: Analysis tool pack is not required.


[Edit] Just for fun I pasted the function down 10,000 rows
and calculated the percentage of the time each character came up.

The average rate of occurence for the numbers was:
stdev of 0.001412012 average of 0.01596

Upper Case Letters
stdev of 0.001964344 average of 0.032323077

Lower Case Letters
stdev 0.001964344 average 0.032323077 (interesting exactly the same as for upper?)

Hi, Teacher,

How do you count the lcase and ucase ?
A
a
a
A

=countif(range,"a") gives me 4
=countif(range,"A") gives me 4

kind regards,
Erik

Good thinking Erik,
That's why I was getting exactly the same statistics. The count wasn't differenciating between the two. (the upper and lower case were produced correctly, but to differenciate when I counted upper and lower I should have used the Exact() function. Don't have time to play now. Keep up the good work!

this is the formula to use
perhaps easy for the experts, for me it was 15 minutes of research and experimenting

kind regards,
Erik

Please have a look on the following created by Chinese Excel lover

1:
=CHAR(LARGE({0,33,65}+ROW(32:57),INT(RAND()*62)+1))

2:
{=CHAR(LARGE({0,33,65}+ROW(32:57),INT(RAND()*62)+1))}

Just saw that post:

http://www.mrexcel.com/board2/viewtopic.php?t=156081&start=30

Outstanding!

But, I would include the $ in the Row function. This was you can paste the formula down as needed.

{=CHAR(LARGE({0,33,65}+ROW($32:$57),INT(RAND()*62)+1))}

5-7 Password generator,it's up to you to decide which characters to disappear in the password.

Take a look at
http://www.ozgrid.com/forum/showthread.php?t=37267