generate all 7-letter formations, maximum 3 letters repeated.

piter

Active Member
Joined
Jul 22, 2011
Messages
316
Office Version
  1. 2016
Platform
  1. Windows
generate all 7-letter formations, maximum 3 letters repeated.
ex = aaabcde ... bbbcccd, etc.
we have 10 letters = abcdefghij to conbine the formations with 7 letters
please!
 
Not relevant now, but just out of curiosity,

another way to calculate the total number of combinations: all the combinations minus the combinations with 4 repeated elements:

=COMBINA(10,7)-10*COMBINA(10,3)

=9240
 
  • Like
Reactions: shg
Upvote 0

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
COMBINA -- a multi-choose function. That was a nice addition (I use 2010).

=COMBIN(10 + 7 - 1, 7) - 10 * COMBIN(10 + 3 - 1, 3)
 
Last edited:
Upvote 0
I just noticed that there are several patterns that have NEVER come out in the 20 year history of the UK Lotto. Not to say they won't ever appear, but these combos are seriouslyunlikely!


You realize those are not equally likely?

Here's is the frequency of those patterns for 49 choose 6, and the expected number of appearances in 7300 draws (daily for 20 years):

13,983,816​
7,300​
AAAAAA
84​
0.04​
AAAAAB
1,260​
0.66​
AAAABB
5,670​
2.96​
AAABBB
10,080​
5.26​
AABBBB
7,560​
3.95​
ABBBBB
2,268​
1.18​
BBBBBB
210​
0.11​
AAAAAC
1,260​
0.66​
AAAABC
12,600​
6.58​
AAABBC
37,800​
19.73​
AABBBC
43,200​
22.55​
ABBBBC
18,900​
9.87​
BBBBBC
2,520​
1.32​
AAAACC
5,670​
2.96​
AAABCC
37,800​
19.73​
AABBCC
72,900​
38.06​
ABBBCC
48,600​
25.37​
BBBBCC
9,450​
4.93​
AAACCC
10,080​
5.26​
AABCCC
43,200​
22.55​
ABBCCC
48,600​
25.37​
BBBCCC
14,400​
7.52​
AACCCC
7,560​
3.95​
ABCCCC
18,900​
9.87​
BBCCCC
9,450​
4.93​
ACCCCC
2,268​
1.18​
BCCCCC
2,520​
1.32​
CCCCCC
210​
0.11​
AAAAAD
1,260​
0.66​
AAAABD
12,600​
6.58​
AAABBD
37,800​
19.73​
AABBBD
43,200​
22.55​
ABBBBD
18,900​
9.87​
BBBBBD
2,520​
1.32​
AAAACD
12,600​
6.58​
AAABCD
84,000​
43.85​
AABBCD
162,000​
84.57​
ABBBCD
108,000​
56.38​
BBBBCD
21,000​
10.96​
AAACCD
37,800​
19.73​
AABCCD
162,000​
84.57​
ABBCCD
182,250​
95.14​
BBBCCD
54,000​
28.19​
AACCCD
43,200​
22.55​
ABCCCD
108,000​
56.38​
BBCCCD
54,000​
28.19​
ACCCCD
18,900​
9.87​
BCCCCD
21,000​
10.96​
CCCCCD
2,520​
1.32​
AAAADD
5,670​
2.96​
AAABDD
37,800​
19.73​
AABBDD
72,900​
38.06​
ABBBDD
48,600​
25.37​
BBBBDD
9,450​
4.93​
AAACDD
37,800​
19.73​
AABCDD
162,000​
84.57​
ABBCDD
182,250​
95.14​
BBBCDD
54,000​
28.19​
AACCDD
72,900​
38.06​
ABCCDD
182,250​
95.14​
BBCCDD
91,125​
47.57​
ACCCDD
48,600​
25.37​
BCCCDD
54,000​
28.19​
CCCCDD
9,450​
4.93​
AAADDD
10,080​
5.26​
AABDDD
43,200​
22.55​
ABBDDD
48,600​
25.37​
BBBDDD
14,400​
7.52​
AACDDD
43,200​
22.55​
ABCDDD
108,000​
56.38​
BBCDDD
54,000​
28.19​
ACCDDD
48,600​
25.37​
BCCDDD
54,000​
28.19​
CCCDDD
14,400​
7.52​
AADDDD
7,560​
3.95​
ABDDDD
18,900​
9.87​
BBDDDD
9,450​
4.93​
ACDDDD
18,900​
9.87​
BCDDDD
21,000​
10.96​
CCDDDD
9,450​
4.93​
ADDDDD
2,268​
1.18​
BDDDDD
2,520​
1.32​
CDDDDD
2,520​
1.32​
DDDDDD
210​
0.11​
AAAAAE
1,260​
0.66​
AAAABE
12,600​
6.58​
AAABBE
37,800​
19.73​
AABBBE
43,200​
22.55​
ABBBBE
18,900​
9.87​
BBBBBE
2,520​
1.32​
AAAACE
12,600​
6.58​
AAABCE
84,000​
43.85​
AABBCE
162,000​
84.57​
ABBBCE
108,000​
56.38​
BBBBCE
21,000​
10.96​
AAACCE
37,800​
19.73​
AABCCE
162,000​
84.57​
ABBCCE
182,250​
95.14​
BBBCCE
54,000​
28.19​
AACCCE
43,200​
22.55​
ABCCCE
108,000​
56.38​
BBCCCE
54,000​
28.19​
ACCCCE
18,900​
9.87​
BCCCCE
21,000​
10.96​
CCCCCE
2,520​
1.32​
AAAADE
12,600​
6.58​
AAABDE
84,000​
43.85​
AABBDE
162,000​
84.57​
ABBBDE
108,000​
56.38​
BBBBDE
21,000​
10.96​
AAACDE
84,000​
43.85​
AABCDE
360,000​
187.93​
ABBCDE
405,000​
211.42​
BBBCDE
120,000​
62.64​
AACCDE
162,000​
84.57​
ABCCDE
405,000​
211.42​
BBCCDE
202,500​
105.71​
ACCCDE
108,000​
56.38​
BCCCDE
120,000​
62.64​
CCCCDE
21,000​
10.96​
AAADDE
37,800​
19.73​
AABDDE
162,000​
84.57​
ABBDDE
182,250​
95.14​
BBBDDE
54,000​
28.19​
AACDDE
162,000​
84.57​
ABCDDE
405,000​
211.42​
BBCDDE
202,500​
105.71​
ACCDDE
182,250​
95.14​
BCCDDE
202,500​
105.71​
CCCDDE
54,000​
28.19​
AADDDE
43,200​
22.55​
ABDDDE
108,000​
56.38​
BBDDDE
54,000​
28.19​
ACDDDE
108,000​
56.38​
BCDDDE
120,000​
62.64​
CCDDDE
54,000​
28.19​
ADDDDE
18,900​
9.87​
BDDDDE
21,000​
10.96​
CDDDDE
21,000​
10.96​
DDDDDE
2,520​
1.32​
AAAAEE
5,670​
2.96​
AAABEE
37,800​
19.73​
AABBEE
72,900​
38.06​
ABBBEE
48,600​
25.37​
BBBBEE
9,450​
4.93​
AAACEE
37,800​
19.73​
AABCEE
162,000​
84.57​
ABBCEE
182,250​
95.14​
BBBCEE
54,000​
28.19​
AACCEE
72,900​
38.06​
ABCCEE
182,250​
95.14​
BBCCEE
91,125​
47.57​
ACCCEE
48,600​
25.37​
BCCCEE
54,000​
28.19​
CCCCEE
9,450​
4.93​
AAADEE
37,800​
19.73​
AABDEE
162,000​
84.57​
ABBDEE
182,250​
95.14​
BBBDEE
54,000​
28.19​
AACDEE
162,000​
84.57​
ABCDEE
405,000​
211.42​
BBCDEE
202,500​
105.71​
ACCDEE
182,250​
95.14​
BCCDEE
202,500​
105.71​
CCCDEE
54,000​
28.19​
AADDEE
72,900​
38.06​
ABDDEE
182,250​
95.14​
BBDDEE
91,125​
47.57​
ACDDEE
182,250​
95.14​
BCDDEE
202,500​
105.71​
CCDDEE
91,125​
47.57​
ADDDEE
48,600​
25.37​
BDDDEE
54,000​
28.19​
CDDDEE
54,000​
28.19​
DDDDEE
9,450​
4.93​
AAAEEE
10,080​
5.26​
AABEEE
43,200​
22.55​
ABBEEE
48,600​
25.37​
BBBEEE
14,400​
7.52​
AACEEE
43,200​
22.55​
ABCEEE
108,000​
56.38​
BBCEEE
54,000​
28.19​
ACCEEE
48,600​
25.37​
BCCEEE
54,000​
28.19​
CCCEEE
14,400​
7.52​
AADEEE
43,200​
22.55​
ABDEEE
108,000​
56.38​
BBDEEE
54,000​
28.19​
ACDEEE
108,000​
56.38​
BCDEEE
120,000​
62.64​
CCDEEE
54,000​
28.19​
ADDEEE
48,600​
25.37​
BDDEEE
54,000​
28.19​
CDDEEE
54,000​
28.19​
DDDEEE
14,400​
7.52​
AAEEEE
7,560​
3.95​
ABEEEE
18,900​
9.87​
BBEEEE
9,450​
4.93​
ACEEEE
18,900​
9.87​
BCEEEE
21,000​
10.96​
CCEEEE
9,450​
4.93​
ADEEEE
18,900​
9.87​
BDEEEE
21,000​
10.96​
CDEEEE
21,000​
10.96​
DDEEEE
9,450​
4.93​
AEEEEE
2,268​
1.18​
BEEEEE
2,520​
1.32​
CEEEEE
2,520​
1.32​
DEEEEE
2,520​
1.32​
EEEEEE
210​
0.11​
[td="bgcolor:#F3F3F3"]
Pattern
[/td][td="bgcolor:#F3F3F3"]
Count
[/td][td="bgcolor:#F3F3F3"]
Expect
[/td]
 
Upvote 0
And for the front- and back-end patterns, the expected number of occurrences:

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]
E​
[/td][td="bgcolor:#C0C0C0"]
F​
[/td][td="bgcolor:#C0C0C0"]
G​
[/td][td="bgcolor:#C0C0C0"]
H​
[/td][td="bgcolor:#C0C0C0"]
I​
[/td][/tr][tr][td="bgcolor:#C0C0C0"]
2​
[/td][td="bgcolor:#F3F3F3"]
Front
[/td][td="bgcolor:#F3F3F3"]
Expect
[/td][td][/td][td="bgcolor:#F3F3F3"]
Back
[/td][td="bgcolor:#F3F3F3"]
Expect
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
3​
[/td][td]AAA[/td][td="bgcolor:#CCFFCC"]
487.23​
[/td][td][/td][td]AAA[/td][td="bgcolor:#FFFF00"]
0.04​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
4​
[/td][td]AAB[/td][td="bgcolor:#CCFFCC"]
1202.48​
[/td][td][/td][td]AAB[/td][td]
0.66​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
5​
[/td][td]AAC[/td][td]
423.97​
[/td][td][/td][td]AAC[/td][td="bgcolor:#FFFF00"]
0.66​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
6​
[/td][td]AAD[/td][td]
87.11​
[/td][td][/td][td]AAD[/td][td="bgcolor:#FFFF00"]
0.66​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
7​
[/td][td]AAE[/td][td]
3.95​
[/td][td][/td][td]AAE[/td][td="bgcolor:#FFFF00"]
0.66​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
8​
[/td][td]ABB[/td][td="bgcolor:#CCFFCC"]
1134.41​
[/td][td][/td][td]ABB[/td][td="bgcolor:#FFFF00"]
2.96​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
9​
[/td][td]ABC[/td][td="bgcolor:#CCFFCC"]
1059.93​
[/td][td][/td][td]ABC[/td][td="bgcolor:#FFFF00"]
6.58​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
10​
[/td][td]ABD[/td][td]
217.77​
[/td][td][/td][td]ABD[/td][td]
6.58​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
11​
[/td][td]ABE[/td][td]
9.87​
[/td][td][/td][td]ABE[/td][td]
6.58​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
12​
[/td][td]ACC[/td][td]
369.06​
[/td][td][/td][td]ACC[/td][td]
2.96​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
13​
[/td][td]ACD[/td][td]
217.77​
[/td][td][/td][td]ACD[/td][td]
6.58​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
14​
[/td][td]ACE[/td][td]
9.87​
[/td][td][/td][td]ACE[/td][td]
6.58​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
15​
[/td][td]ADD[/td][td]
61.79​
[/td][td][/td][td]ADD[/td][td]
2.96​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
16​
[/td][td]ADE[/td][td]
9.87​
[/td][td][/td][td]ADE[/td][td]
6.58​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
17​
[/td][td]AEE[/td][td="bgcolor:#FFFF00"]
1.18​
[/td][td][/td][td]AEE[/td][td]
2.96​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
18​
[/td][td]BBB[/td][td]
306.08​
[/td][td][/td][td]BBB[/td][td]
10.50​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
19​
[/td][td]BBC[/td][td="bgcolor:#CCFFCC"]
529.97​
[/td][td][/td][td]BBC[/td][td]
53.47​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
20​
[/td][td]BBD[/td][td]
108.88​
[/td][td][/td][td]BBD[/td][td]
53.47​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
21​
[/td][td]BBE[/td][td]
4.93​
[/td][td][/td][td]BBE[/td][td]
53.47​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
22​
[/td][td]BCC[/td][td]
410.07​
[/td][td][/td][td]BCC[/td][td]
88.09​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
23​
[/td][td]BCD[/td][td]
241.96​
[/td][td][/td][td]BCD[/td][td]
195.76​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
24​
[/td][td]BCE[/td][td]
10.96​
[/td][td][/td][td]BCE[/td][td]
195.76​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
25​
[/td][td]BDD[/td][td]
68.66​
[/td][td][/td][td]BDD[/td][td]
88.09​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
26​
[/td][td]BDE[/td][td]
10.96​
[/td][td][/td][td]BDE[/td][td]
195.76​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
27​
[/td][td]BEE[/td][td="bgcolor:#FFFF00"]
1.32​
[/td][td][/td][td]BEE[/td][td]
88.09​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
28​
[/td][td]CCC[/td][td]
94.98​
[/td][td][/td][td]CCC[/td][td]
82.06​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
29​
[/td][td]CCD[/td][td]
108.88​
[/td][td][/td][td]CCD[/td][td]
356.90​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
30​
[/td][td]CCE[/td][td="bgcolor:#FFFF00"]
4.93​
[/td][td][/td][td]CCE[/td][td]
356.90​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
31​
[/td][td]CDD[/td][td]
68.66​
[/td][td][/td][td]CDD[/td][td="bgcolor:#CCFFCC"]
466.89​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
32​
[/td][td]CDE[/td][td]
10.96​
[/td][td][/td][td]CDE[/td][td="bgcolor:#CCFFCC"]
1037.54​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
33​
[/td][td]CEE[/td][td="bgcolor:#FFFF00"]
1.32​
[/td][td][/td][td]CEE[/td][td]
466.89​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
34​
[/td][td]DDD[/td][td]
13.88​
[/td][td][/td][td]DDD[/td][td]
277.33​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
35​
[/td][td]DDE[/td][td]
4.93​
[/td][td][/td][td]DDE[/td][td="bgcolor:#CCFFCC"]
1145.82​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
36​
[/td][td]DEE[/td][td="bgcolor:#FFFF00"]
1.32​
[/td][td][/td][td]DEE[/td][td="bgcolor:#CCFFCC"]
1374.25​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
37​
[/td][td]EEE[/td][td="bgcolor:#FFFF00"]
0.11​
[/td][td][/td][td]EEE[/td][td="bgcolor:#CCFFCC"]
658.98​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
38​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
39​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
40​
[/td][td][/td][td="bgcolor:#CCFFCC"]
60.5%​
[/td][td][/td][td][/td][td="bgcolor:#CCFFCC"]
64.2%​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
41​
[/td][td][/td][td="bgcolor:#FFFF00"]
0.1%​
[/td][td][/td][td][/td][td="bgcolor:#FFFF00"]
0.2%​
[/td][/tr]
[/table]


The yellow ones are those you haven't seen; not surprisingly, they are among least likely. And conversely, the most frequent appearing are among the most likely.

Your Lotto looks comfortingly random.
 
Last edited:
Upvote 0
COMBINA -- a multi-choose function. That was a nice addition (I use 2010).

I didn't know either. I checked which were the new functions for 2013 but I missed this one.
It was just when I started to write the formula and intellisence showed this new option that I realised that it existed.

IMO, these functions were lacking. If you had functions for combinations and permutations without repetition, it makes sense to have the same functions for the case of repetition.

Interesting how they built the names of the new functions differently for the 2 cases

COMBIN() - COMBINA()
PERMUT() - PERMUTATIONA()

??
 
Upvote 0
For the front end triple, only 16 combinations make up 95% of the winning combinations. These are (listed by number of hits):
AAB, ABB, ABC, AAC, AAA, BBC, ACC, BCC, BBB, ACD, BCD, ABD, AAD, CCC, CCD and BBD

And, for the back-end triple only 15 combinations are used 95% of the time:
DEE, DDE, CDE, EEE, CDD, CEE, CCD, CCE, DDD, BCE, BDE, BCD, BDD, CCC and BBD.

As you should expect:

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]
I​
[/td][td="bgcolor:#C0C0C0"]
J​
[/td][td="bgcolor:#C0C0C0"]
K​
[/td][td="bgcolor:#C0C0C0"]
L​
[/td][td="bgcolor:#C0C0C0"]
M​
[/td][/tr][tr][td="bgcolor:#C0C0C0"]
2​
[/td][td="bgcolor:#F3F3F3"]
Pattern
[/td][td="bgcolor:#F3F3F3"]
Expected Front
[/td][td][/td][td="bgcolor:#F3F3F3"]
Pattern
[/td][td="bgcolor:#F3F3F3"]
Expected Back
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
3​
[/td][td]AAB[/td][td="bgcolor:#CCFFCC"]
1202.48​
[/td][td][/td][td]DEE[/td][td="bgcolor:#CCFFCC"]
1374.25​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
4​
[/td][td]ABB[/td][td="bgcolor:#CCFFCC"]
1134.41​
[/td][td][/td][td]DDE[/td][td="bgcolor:#CCFFCC"]
1145.82​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
5​
[/td][td]ABC[/td][td="bgcolor:#CCFFCC"]
1059.93​
[/td][td][/td][td]CDE[/td][td="bgcolor:#CCFFCC"]
1037.54​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
6​
[/td][td]BBC[/td][td="bgcolor:#CCFFCC"]
529.97​
[/td][td][/td][td]EEE[/td][td="bgcolor:#CCFFCC"]
658.98​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
7​
[/td][td]AAA[/td][td="bgcolor:#CCFFCC"]
487.23​
[/td][td][/td][td]CDD[/td][td="bgcolor:#CCFFCC"]
466.89​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
8​
[/td][td]AAC[/td][td="bgcolor:#CCFFCC"]
423.97​
[/td][td][/td][td]CEE[/td][td="bgcolor:#CCFFCC"]
466.89​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
9​
[/td][td]BCC[/td][td="bgcolor:#CCFFCC"]
410.07​
[/td][td][/td][td]CCD[/td][td="bgcolor:#CCFFCC"]
356.90​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
10​
[/td][td]ACC[/td][td="bgcolor:#CCFFCC"]
369.06​
[/td][td][/td][td]CCE[/td][td="bgcolor:#CCFFCC"]
356.90​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
11​
[/td][td]BBB[/td][td="bgcolor:#CCFFCC"]
306.08​
[/td][td][/td][td]DDD[/td][td="bgcolor:#CCFFCC"]
277.33​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
12​
[/td][td]BCD[/td][td="bgcolor:#CCFFCC"]
241.96​
[/td][td][/td][td]BCD[/td][td="bgcolor:#CCFFCC"]
195.76​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
13​
[/td][td]ABD[/td][td="bgcolor:#CCFFCC"]
217.77​
[/td][td][/td][td]BCE[/td][td="bgcolor:#CCFFCC"]
195.76​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
14​
[/td][td]ACD[/td][td="bgcolor:#CCFFCC"]
217.77​
[/td][td][/td][td]BDE[/td][td="bgcolor:#CCFFCC"]
195.76​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
15​
[/td][td]BBD[/td][td="bgcolor:#CCFFCC"]
108.88​
[/td][td][/td][td]BCC[/td][td]
88.09​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
16​
[/td][td]CCD[/td][td="bgcolor:#CCFFCC"]
108.88​
[/td][td][/td][td]BDD[/td][td="bgcolor:#CCFFCC"]
88.09​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
17​
[/td][td]CCC[/td][td="bgcolor:#CCFFCC"]
94.98​
[/td][td][/td][td]BEE[/td][td]
88.09​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
18​
[/td][td]AAD[/td][td="bgcolor:#CCFFCC"]
87.11​
[/td][td][/td][td]CCC[/td][td="bgcolor:#CCFFCC"]
82.06​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
19​
[/td][td]BDD[/td][td]
68.66​
[/td][td][/td][td]BBC[/td][td]
53.47​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
20​
[/td][td]CDD[/td][td]
68.66​
[/td][td][/td][td]BBD[/td][td="bgcolor:#CCFFCC"]
53.47​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
21​
[/td][td]ADD[/td][td]
61.79​
[/td][td][/td][td]BBE[/td][td]
53.47​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
22​
[/td][td]DDD[/td][td]
13.88​
[/td][td][/td][td]BBB[/td][td]
10.50​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
23​
[/td][td]BCE[/td][td]
10.96​
[/td][td][/td][td]ABC[/td][td]
6.58​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
24​
[/td][td]BDE[/td][td]
10.96​
[/td][td][/td][td]ABD[/td][td]
6.58​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
25​
[/td][td]CDE[/td][td]
10.96​
[/td][td][/td][td]ACD[/td][td]
6.58​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
26​
[/td][td]ABE[/td][td]
9.87​
[/td][td][/td][td]ABE[/td][td]
6.58​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
27​
[/td][td]ACE[/td][td]
9.87​
[/td][td][/td][td]ACE[/td][td]
6.58​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
28​
[/td][td]ADE[/td][td]
9.87​
[/td][td][/td][td]ADE[/td][td]
6.58​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
29​
[/td][td]BBE[/td][td]
4.93​
[/td][td][/td][td]ABB[/td][td]
2.96​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
30​
[/td][td]CCE[/td][td]
4.93​
[/td][td][/td][td]ACC[/td][td]
2.96​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
31​
[/td][td]DDE[/td][td]
4.93​
[/td][td][/td][td]ADD[/td][td]
2.96​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
32​
[/td][td]AAE[/td][td]
3.95​
[/td][td][/td][td]AEE[/td][td]
2.96​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
33​
[/td][td]BEE[/td][td]
1.32​
[/td][td][/td][td]AAB[/td][td]
0.66​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
34​
[/td][td]CEE[/td][td]
1.32​
[/td][td][/td][td]AAC[/td][td]
0.66​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
35​
[/td][td]DEE[/td][td]
1.32​
[/td][td][/td][td]AAD[/td][td]
0.66​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
36​
[/td][td]AEE[/td][td]
1.18​
[/td][td][/td][td]AAE[/td][td]
0.66​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
37​
[/td][td]EEE[/td][td]
0.11​
[/td][td][/td][td]AAA[/td][td]
0.04​
[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
38​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
39​
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]
40​
[/td][td][/td][td="bgcolor:#CCFFCC"]
95.9%​
[/td][td][/td][td][/td][td="bgcolor:#CCFFCC"]
95.2%​
[/td][/tr]
[/table]
 
Upvote 0
Cross posted https://www.excelforum.com/excel-pr...-being-a-maximum-of-3-letters-per-column.html

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.
 
Upvote 0
hello SHG, great job, when winning a prize will be rewarded by 20%. thank you
fluff. Sorry, is that as you appreciate the solutions, we can move forward one more step,
to do the crossroads of the patterns, in the same post, thanks
 
Upvote 0

Forum statistics

Threads
1,223,264
Messages
6,171,081
Members
452,377
Latest member
bradfordsam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top