Microsoft Excel

[Nick Vaughn]

Can anyone help me out on this one. I would like to have a formula for Subsets.

 

[Rick Rothstein]

Re: Microsodt Excel

Can anyone help me out on this one. I would like to have a formula for Subsets.

Can we help? Maybe... it depends on what you mean by "subsets". We could try guessing at what your current setup is and what you ultimately want to do with it, but I'm thinking things would move more quickly if you told us.

 

[Ruddles]

Re: Microsodt Excel

Hi Nick, welcome to the board.

On the basis that the quality of the assistance is directly proportional to the quantity of the information provided, may I suggest you take a look at these guidelines.

If you can tell us what you're trying to achieve, preferably with some concrete examples, we'll find it much easier to respond usefully.

 

[Nick Vaughn]

I am looking for a formula that can give me all the possible 6 letter passwords from A to Z using Excel. Its bit time consuming with you have others important tasks to attend to and would also help a great deal not having duplicate passwords for my clients.

 

[Nick Vaughn]

Thanks a lot Rick Rothstein; Awaiting you favorable response.

 

[Ruddles]

I am looking for a formula that can give me all the possible 6 letter passwords from A to Z using Excel. Its bit time consuming with you have others important tasks to attend to and would also help a great deal not having duplicate passwords for my clients.

I have some code which will do exactly this. Where would you like the combinations output to: the worksheet or a text file?

 

[Rick Rothstein]

I'm thinking it may be more efficient for you to simple store the assigned passwords in an encrypted file, load them when you are ready to generate a new password and do a lookup to make sure that newly generated password has not been already assigned. I'm not a statistic person, but if I have done my calculations correctly, the complete list you are asking for would contain over 165 million possible passwords in it (165,765,600 to be exact)... that seems like it might be unwieldy to generate and work with.

 

[Ruddles]

I make it 26^6 or 308,915,776.

My laptop is telling me it'll take about five and a half hours to generate them to a worksheet.

 

[Rick Rothstein]

I make it 26^6 or 308,915,776.

My laptop is telling me it'll take about five and a half hours to generate them to a worksheet.

I said I'm not a statistics person, but I thought this was a "permutations" thing... how many ways can 6 items be made from 26 items? This is the permutations calculator that I used...

http://www.calculatorsoup.com/calculators/discretemathematics/permutations.php

 

[shg]

Rather than list 308M 6-letter passwords from AAAAAA to ZZZZZZ (what a boring parade!), how about a function?

Function Nick(ByVal d As Double, _
              Optional iLen As Long = 0) As String
    Dim avs As Variant
 
    avs = Split("A B C D E F G H I J K L M N O P Q R S T U V W X Y Z", " ")
 
    Do
        Nick = avs(d - Int(d / 26) * 26) & Nick
        d = Int(d / 26)
    Loop While d > 0#
 
    If Len(Nick) < iLen Then Nick = String(iLen - Len(Nick), avs(0)) & Nick
End Function

E.g.,

=Nick(0, 6) returns AAAAAA

=Nick(308915775, 6) returns ZZZZZZ

=Nick(1000000, 6) returns ACEXHO

It just converts the argument to base 26.