Password Generator

[Luigi802]

So, I'm trying to create a random 15 digit password with certain criteria. At least 3 of the following; uppercase, lowercase, special characters, numbers. I also want to make each character unique, I have 2 formulas:

1. =CHAR(RANDBETWEEN(33,122))&CHAR(RANDBETWEEN(33,122))&CHAR(RANDBETWEEN(33,122))&CHAR(RANDBETWEEN(33,122))&CHAR(RANDBETWEEN(33,122))&CHAR(RANDBETWEEN(33,122))&CHAR(RANDBETWEEN(33,122))&CHAR(RANDBETWEEN(33,122))&CHAR(RANDBETWEEN(33,122))&CHAR(RANDBETWEEN(33,122))&CHAR(RANDBETWEEN(33,122))&CHAR(RANDBETWEEN(33,122))&CHAR(RANDBETWEEN(33,122))&CHAR(RANDBETWEEN(33,122))&CHAR(RANDBETWEEN(33,122))

This creates a random PW all unique, but does not stick to the criteria all the time


2. =CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(42,43))&CHAR(RANDBETWEEN(42,43))&CHAR(RANDBETWEEN(42,43))&RANDBETWEEN(100000,999999)

This 1 sticks to my criteria but creates repeat characters, and is ALWAYS formatted "Uppercase, Lowercase, Lowercase, Lowercase, Uppercase, Uppercase, Special Character, Special Character, Special Character, and then 6 numbers, or however I arrange the formula.

Basically if I could modify the 1st formula to always have at least 3 of each character, but not always in the same order with no repeats! I'm also open to VBA code; although, I am a noob at that!

 

[GraH - Guido]

I'm no expert, but I've read that Excel is not that great for generating random numbers (statistically speaking).
From a security point of view: by now every hackers knows you want to use Excel for generating passwords. And how you are building it.
Just saying that there are free password tools available that generate better random passwords while keeping them in a safer encrypted environment following high end security standards. Perhaps you need to consider one of those.

 

[NARAYANK991]

Hi ,

See the attached file.

The generated passwords are in column J , and have been generated using VBA.

Narayan

 

[Haz]

And without VBA.

EDIT: http://support.microsoft.com/kb/828795
RAND in earlier versions of Excel isn't random enough if you're generating a huge quantity of numbers, for the average user there's no difference.
RAND in 2003 and earlier versions is better at generating random numbers.

 

[pecoflyer]

Cross posted elsewehere

 

[Luigi802]

Cross posted elsewehere

I apologize, I didn't get a response from the other site, I forgot about that rule about cross posting, but thank you for reminding me

 

[Luigi802]

And without VBA.

EDIT: http://support.microsoft.com/kb/828795
RAND in earlier versions of Excel isn't random enough if you're generating a huge quantity of numbers, for the average user there's no difference.
RAND in 2003 and earlier versions is better at generating random numbers.

Thank you, that worked great!