List number of permutations for text nums
Just a minor modification eliminating the need for the J$1:K$5 table
=INDEX({24,0,12,6,4,1},SUM(LARGE(FREQUENCY(--MID(A1,{1,2,3,4},1),--MID(A1,{1,2,3,4},1)),{1;2})*{2;1})-2)
Lars-Åke
On Sun, 29 Nov 2009 13:06:40 -0500, "T. Valko"
wrote:
There may be an easier way to do this but this is the "thought process" I
had and I went with it!
I'm assuming your perm table is correct:
7777 1
1777 4
0044 6
2477 12
1234 24
Let's modify that slightly:
..........J..........K
1......11.........24
2......21.........12
3......22.........6
4......31.........4
5......40.........1
A1 = a four digit *text number*
Formula in B1:
=LOOKUP(SUM(LARGE(FREQUENCY(--MID(A1,{1,2,3,4},1),--MID(A1,{1,2,3,4},1)),{1;2})*{10;1}),J$1:K$5)
|