Excel Key Combination

[collinsc]

Hi

Outside the door of my flat I have a key holder – which has a combination of 4 digits. No-one knows what the combination is, so I’d like to try to find it, clear it and use it.
I wondered if there was a way to use excel to show all of the possible combinations so I can then tick them off as I try them…?

The possible numbers are 0-9, but you cant press a button more than once in any given attempt… so… first possible combination would be 0123… not 0001.

Thanks

[sweep]

Hi,

This code

Please Login or Register  to view this content.

found here will do what you want.

[teylyn]

Hi,

and as an alternative to a macro approach, see attached ....

- created the first valid number in A2 = 123
- in A3 put =A1+1
- in column B put =TEXT(A2,"0000")
- In columns C, D, E and F put respectively

Please Login or Register  to view this content.

- in column G put =COUNTIF(C2:F2,C2)+COUNTIF(C2:F2,D2)+COUNTIF(C2:F2,E2)+COUNTIF(C2:F2,F2)=4
- copy A to G down to row 9755
- click in the table and activate Autofilter (Data - Filter - Autofilter)
- select "TRUE" only in the dropdown filter for Column G
- hide columns A, C to G

Try not to kill too many trees printing the list. With unchanged standard settings and A4 paper, this will produce a 100 page printout. But you could try to copy and paste special - Values to create several columns on one single sheet and bring the printout down to 20 pages.

There are probably more elegant ways to produce the list, but I'm sure there aren't any duplicate digits in the numbers still showing!

Happy trialling.

[martindwilson]

heres the list 10 pages long

[Domski]

Cross Post: http://www.mrexcel.com/forum/showthread.php?p=2161035

@ CollinsC: Please read this: http://www.excelguru.ca/node/7

Dom

[collinsc]

thanks v much

[shg]

If the lock responds to the last 4 digits pressed (like some electronic door locks), then this can be done by pressing 5043 buttons rather than 4 * 5040 = 20,160 buttons,