In previous posts, I made a reference to May 4th on some of those charts. I meant to write June 4th. I’ve posted the June 4th chart here again with a 31 day back test. In addition, I highlighted key 6 in the June 4th chart. Why? It hasn’t shown up for 12 days.
Does anyone know how to program Excel so that if you enter a number as 321 it will show as 123? Why? I use the conditional formatting feature in Excel to perform the back test, but the numbers have to be in same order for a comparison to work.
For example, if you select Conditional Formatting>Highlight Cell Rules> Duplicate Values>on selected combinations>fill cells with pink and format numbers with a red font, the numbers have to be in the same order for the selection to work properly. I'm wondering if I should try a bubble sort in VBA.
JUNE 4TH CHART
|
*
|
LAST 31 DAYS
|
SUM
|
BOX
|
X
|
Y
|
Z
|
*
|
DATE
|
SUM
|
BOX
|
24
|
789
|
7
|
8
|
9
|
*
|
6/28
|
14
|
149
|
23
|
788
|
7
|
8
|
8
|
*
|
6/27
|
10
|
235
|
22
|
778
|
7
|
7
|
8
|
*
|
6/26
|
14
|
338
|
22
|
589
|
5
|
8
|
9
|
*
|
6/25
|
17
|
179
|
21
|
678
|
6
|
7
|
8
|
*
|
6/24
|
18
|
378
|
21
|
579
|
5
|
7
|
9
|
*
|
6/23
|
18
|
288
|
21
|
489
|
4
|
8
|
9
|
*
|
6/22
|
5
|
014
|
19
|
577
|
5
|
7
|
7
|
*
|
6/21
|
16
|
178
|
19
|
559
|
5
|
5
|
9
|
*
|
6/20
|
7
|
124
|
19
|
478
|
4
|
7
|
8
|
*
|
6/19
|
11
|
047
|
19
|
469
|
4
|
6
|
9
|
*
|
6/18
|
21
|
579
|
19
|
388
|
3
|
8
|
8
|
*
|
6/17
|
10
|
037
|
18
|
468
|
4
|
6
|
8
|
*
|
6/16
|
10
|
136
|
18
|
459
|
4
|
5
|
9
|
*
|
6/15
|
13
|
067
|
18
|
369
|
3
|
6
|
9
|
*
|
6/14
|
21
|
579
|
18
|
189
|
1
|
8
|
9
|
*
|
6/13
|
21
|
579
|
18
|
099
|
0
|
9
|
9
|
*
|
6/12
|
14
|
455
|
17
|
557
|
5
|
5
|
7
|
*
|
6/11
|
14
|
059
|
17
|
467
|
4
|
6
|
7
|
*
|
6/10
|
15
|
069
|
17
|
449
|
4
|
4
|
9
|
*
|
6/09
|
5
|
014
|
17
|
377
|
3
|
7
|
7
|
*
|
6/08
|
9
|
135
|
17
|
368
|
3
|
6
|
8
|
*
|
6/07
|
23
|
779
|
17
|
278
|
2
|
7
|
8
|
*
|
6/06
|
3
|
012
|
17
|
269
|
2
|
6
|
9
|
*
|
6/05
|
20
|
677
|
17
|
179
|
1
|
7
|
9
|
*
|
6/04
|
8
|
044
|
17
|
089
|
0
|
8
|
9
|
*
|
6/03
|
12
|
057
|
15
|
456
|
4
|
5
|
6
|
*
|
6/02
|
18
|
378
|
15
|
447
|
4
|
4
|
7
|
*
|
6/01
|
15
|
159
|
15
|
366
|
3
|
6
|
6
|
*
|
5/31
|
9
|
126
|
15
|
357
|
3
|
5
|
7
|
*
|
5/30
|
13
|
049
|
15
|
348
|
3
|
4
|
8
|
*
|
5/29
|
13
|
346
|
15
|
267
|
2
|
6
|
7
|
*
|
*
|
*
|
*
|
15
|
168
|
1
|
6
|
8
|
*
|
*
|
*
|
*
|
15
|
078
|
0
|
7
|
8
|
*
|
*
|
*
|
*
|
15
|
069
|
0
|
6
|
9
|
*
|
*
|
*
|
*
|
14
|
356
|
3
|
5
|
6
|
*
|
*
|
*
|
*
|
14
|
347
|
3
|
4
|
7
|
*
|
*
|
*
|
*
|
14
|
338
|
3
|
3
|
8
|
*
|
*
|
*
|
*
|
14
|
266
|
2
|
6
|
6
|
*
|
*
|
*
|
*
|
14
|
257
|
2
|
5
|
7
|
*
|
*
|
*
|
*
|
14
|
167
|
1
|
6
|
7
|
*
|
*
|
*
|
*
|
14
|
158
|
1
|
5
|
8
|
*
|
*
|
*
|
*
|
14
|
149
|
1
|
4
|
9
|
*
|
*
|
*
|
*
|
14
|
077
|
0
|
7
|
7
|
*
|
*
|
*
|
*
|
14
|
068
|
0
|
6
|
8
|
*
|
*
|
*
|
*
|
14
|
059
|
0
|
5
|
9
|
*
|
*
|
*
|
*
|
13
|
445
|
4
|
4
|
5
|
*
|
*
|
*
|
*
|
13
|
337
|
3
|
3
|
7
|
*
|
*
|
*
|
*
|
13
|
256
|
2
|
5
|
6
|
*
|
*
|
*
|
*
|
13
|
238
|
2
|
3
|
8
|
*
|
*
|
*
|
*
|
13
|
166
|
1
|
6
|
6
|
*
|
*
|
*
|
*
|
13
|
157
|
1
|
5
|
7
|
*
|
*
|
*
|
*
|
13
|
148
|
1
|
4
|
8
|
*
|
*
|
*
|
*
|
13
|
139
|
1
|
3
|
9
|
*
|
*
|
*
|
*
|
13
|
067
|
0
|
6
|
7
|
*
|
*
|
*
|
*
|
13
|
058
|
0
|
5
|
8
|
*
|
*
|
*
|
*
|
12
|
345
|
3
|
4
|
5
|
*
|
*
|
*
|
*
|
12
|
336
|
3
|
3
|
6
|
*
|
*
|
*
|
*
|
12
|
255
|
2
|
5
|
5
|
*
|
*
|
*
|
*
|
12
|
246
|
2
|
4
|
6
|
*
|
*
|
*
|
*
|
12
|
237
|
2
|
3
|
7
|
*
|
*
|
*
|
*
|
12
|
156
|
1
|
5
|
6
|
*
|
*
|
*
|
*
|
12
|
147
|
1
|
4
|
7
|
*
|
*
|
*
|
*
|
12
|
138
|
1
|
3
|
8
|
*
|
*
|
*
|
*
|
12
|
129
|
1
|
2
|
9
|
*
|
*
|
*
|
*
|
12
|
066
|
0
|
6
|
6
|
*
|
*
|
*
|
*
|
12
|
048
|
0
|
4
|
8
|
*
|
*
|
*
|
*
|
12
|
039
|
0
|
3
|
9
|
*
|
*
|
*
|
*
|
10
|
334
|
3
|
3
|
4
|
*
|
*
|
*
|
*
|
10
|
244
|
2
|
4
|
4
|
*
|
*
|
*
|
*
|
10
|
235
|
2
|
3
|
5
|
*
|
*
|
*
|
*
|
10
|
226
|
2
|
2
|
6
|
*
|
*
|
*
|
*
|
10
|
145
|
1
|
4
|
5
|
*
|
*
|
*
|
*
|
10
|
136
|
1
|
3
|
6
|
*
|
*
|
*
|
*
|
10
|
127
|
1
|
2
|
7
|
*
|
*
|
*
|
*
|
10
|
055
|
0
|
5
|
5
|
*
|
*
|
*
|
*
|
10
|
037
|
0
|
3
|
7
|
*
|
*
|
*
|
*
|
9
|
234
|
2
|
3
|
4
|
*
|
*
|
*
|
*
|
9
|
225
|
2
|
2
|
5
|
*
|
*
|
*
|
*
|
9
|
144
|
1
|
4
|
4
|
*
|
*
|
*
|
*
|
9
|
045
|
0
|
4
|
5
|
*
|
*
|
*
|
*
|
9
|
036
|
0
|
3
|
6
|
*
|
*
|
*
|
*
|
9
|
027
|
0
|
2
|
7
|
*
|
*
|
*
|
*
|
9
|
009
|
0
|
0
|
9
|
*
|
*
|
*
|
*
|
8
|
044
|
0
|
4
|
4
|
*
|
*
|
*
|
*
|
8
|
035
|
0
|
3
|
5
|
*
|
*
|
*
|
*
|
8
|
026
|
0
|
2
|
6
|
*
|
*
|
*
|
*
|
6
|
114
|
1
|
1
|
4
|
*
|
*
|
*
|
*
|
6
|
024
|
0
|
2
|
4
|
*
|
*
|
*
|
*
|
6
|
015
|
0
|
1
|
5
|
*
|
*
|
*
|
*
|
6
|
006
|
0
|
0
|
6
|
*
|
*
|
*
|
*
|
5
|
014
|
0
|
1
|
4
|
*
|
*
|
*
|
*
|
5
|
005
|
0
|
0
|
5
|
*
|
*
|
*
|
*
|
4
|
013
|
0
|
1
|
3
|
*
|
*
|
*
|
*
|
4
|
004
|
0
|
0
|
4
|
*
|
*
|
*
|
*
|
3
|
012
|
0
|
1
|
2
|
*
|
*
|
*
|
*
|