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]

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td="bgcolor:#F3F3F3"]

Combo​

[/td][td="bgcolor:#F3F3F3"]

OK​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]0000[/td][td]

FALSE​

[/td][td]B2: =AND(MID(A2, {1,2,3}, 1) < MID(A2, {2,3,4}, 1))[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td]0001[/td][td]

FALSE​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

4​

[/td][td]0002[/td][td]

FALSE​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

5​

[/td][td]0003[/td][td]

FALSE​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

124​

[/td][td]0122[/td][td]

FALSE​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

125​

[/td][td]0123[/td][td]

TRUE​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

126​

[/td][td]0124[/td][td]

TRUE​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

127​

[/td][td]0125[/td][td]

TRUE​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

128​

[/td][td]0126[/td][td]

TRUE​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

129​

[/td][td]0127[/td][td]

TRUE​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

130​

[/td][td]0128[/td][td]

TRUE​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

131​

[/td][td]0129[/td][td]

TRUE​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

132​

[/td][td]0130[/td][td]

FALSE​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

135​

[/td][td]0133[/td][td]

FALSE​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

136​

[/td][td]0134[/td][td]

TRUE​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

137​

[/td][td]0135[/td][td]

TRUE​

[/td][td][/td][/tr]
[/table]

 

[EssKayKay]

Thank you SHG I got it - much appreciated.

Again, my thanks...
SKK

 

[shg]

You're welcome.