Four Digit Possibilities

[EssKayKay]

Hello,


I’m looking for the total number of possibilities for a four digit entry where:

1. Available digits = 0,1,2,3,4,5,6,7,8,9.
2. Any single digit can only be used once.
3. Any combination of four digits are equal and only counted as one possibility (i.e., 0123, 3210, 1230, 2130 etc. are all only one option).

Any suggestion would be appreciated,

Thanks,
SKK

 

[shg]

=combin(10,4)

 

[EssKayKay]

So that tells me 210 possibilities. Is there a way to list these in a spreadsheet?

Thanks,
SKK

 

[shg]

Enter 0000 into a cell formatted as text, drag down 10000 rows, and write a formula to tells you the digits are in order. Filter on that, clear the ones that aren't, and sort to move blanks to the bottom.

 

[EssKayKay]

Sorry for being a pain here but I have no idea how to write a formula to test if digits are in order.

 

[shg]

	A​	B​	C​
1​	Combo​	OK​
2​	0000	FALSE​	B2: =AND(MID(A2, {1,2,3}, 1) < MID(A2, {2,3,4}, 1))
3​	0001	FALSE​
4​	0002	FALSE​
5​	0003	FALSE​
124​	0122	FALSE​
125​	0123	TRUE​
126​	0124	TRUE​
127​	0125	TRUE​
128​	0126	TRUE​
129​	0127	TRUE​
130​	0128	TRUE​
131​	0129	TRUE​
132​	0130	FALSE​
135​	0133	FALSE​
136​	0134	TRUE​
137​	0135	TRUE​

 

[EssKayKay]

Thank you SHG I got it - much appreciated.

Again, my thanks...
SKK

 

[shg]

You're welcome.