ABCDEFGHIJKLMNOPQRSTUV
1
0.12300023810.1729999669
2
Sample ItemsStep 1️⃣ Sort + IndexesStep 2️⃣ Group Starts + CountersStep 3️⃣ Sort BackFinaly. Combine the formula← Improved by Tom Sharpe
3
68511230111
4
a1510211
5
a11390322
6
a13180433
7
a14110544
8
a14450655
9
2218314490711
10
9 14840811
11
7415910911
12
13163201011
13
10166701111
14
b171001211
15
b171401322
16
2872173601411
17
18178001511
18
21179501611
19
18186301722
20
12440187501811
21
5198101911
22
5531104802011
23
211107302122
24
21116902211
25
11133602311
26
131137702422
27
154661140302511
28
3541141102611
29
199861141902711
30
141159702811
31
53871166802911
32
211172503033
33
101172803122
34
171174303211
35
156341180803311
36
111184503411
37
61186303511
38
122471186903611
39
93552221111
40
232650211
41
5992810311
42
72870411
43
70722940511
44
1775221920611
45
1919122620711
46
1388423090811
47
2094923560911
48
11495237301011
49
11252401122
50
3253301211
51
20253501311
52
21256101444
53
1258001522
54
20614259201611
55
10260501733
56
12297262501811
57
12272401911
58
19273202011
59
8274002111
60
12146280202211
61
2617288302311
62
17294102422
63
3296002522
64
236432100502611
65
132104602733
66
243762110702811
67
22119702922
68
165502129403011
69
182130403133
70
246112131103211
71
50392132403311
72
153882133303411
73
7722137403511
74
226442148803611
75
72942150003711
76
136612152803811
77
105592157103911
78
49792158704011
79
202162104122
80
162165204211
81
80552165904311
82
142166404422
83
22175004533
84
65422177404611
85
174302182204711
86
241742186804811
87
217502193604911
88
92197005022
89
23481144
90
5633610211
91
531170322
92
1331370444
93
2331750522
94
2330732460611
95
2028433310711
96
234030855
97
704634090911
98
25346401011
99
2907348001111
100
4349601211