How to find all of the possible combinations of a four digit code

Try this code - the key is that it cannot create duplicated digits, and the digits are in ascending order:

Please Login or Register  to view this content.

Follow the instructions here:

https://peltiertech.com/how-to-use-s...d%20press%20F5

Here is a formula solution.

I borrowed heavily from a solution to a similar problem José Augusto solved here: https://www.excelforum.com/excel-for...n-results.html

The problem (sum of values) is different than yours but the issue of unique combinations is identical.
The approach is to first identify all combinations of 4 digits by unique positions.

Use G1:P1 to store all digits for reference.

	G	H	I	J	K	L	M	N	O	P
1	0	1	2	3	4	5	6	7	8	9

Continued in next post. Forum won't let me edit this one.

In D1 of the attached find

Formula:

Please Login or Register  to view this content.

This returns the number of unique combinations of 4 of 10 digits. In E1 this formula

Formula:

Please Login or Register  to view this content.

validates the count yielded by this solution.

Define unique combinations using binary values where each of the digits is expected. IE 1s where the digits are desired and 0s where not. This is done by first determining the smallest decimal value defined by the binary value 1111000000 (unique combination of G1:P1 "0123") and the largest decimal value defined by the binary value 0000001111 (unique combination of G1:P1 "6789"). Those formulas are in B1 and C1

Formula:

Please Login or Register  to view this content.

and

Formula:

Please Login or Register  to view this content.

respectively.

You will need to test all values from 15 to 960 (all 946 numbers) to find those 210 the COMBIN formula indicates. See A2:A947.

In B2:B947 determine which of those decimal numbers' binary equivalent consists of 4 1s only. This formula does that. It is the basis of José's solution (compacted somewhat).

Formula:

Please Login or Register  to view this content.

In G2:P947 this "translates" those unique combinations of 4 1s to the corresponding digits in G1:P1

Formula:

Please Login or Register  to view this content.

In Q2:Q947 this concatenates those digits into their unique combinations ... all 210 of them.

Formula:

Please Login or Register  to view this content.

Let me know if you have any questions.

Hi November and welcome to the forum,

I agree with FlameRetired above. There are 210 possible answers. See the attached where the first 4 columns are all possible 0-9 four digit combinations. In the next columns are those numbers sorted from small to large. Third I did an advanced filter of the second table and only show unique combinations. I used some VBA to build the first and second columns.
Possible Lock Combos.xlsm

BTW - I have one of those locks where you push in the buttons to get the combo. My combo is 6897 which is really 6789 as the order doesn't matter. I remember the easy one and give out the harder to remember combo.