Re: Number Selection - Extension
Hi All,
Extending from another thread posted Re: Number SelectionOct 24th, 2019 I am looking to analyze multiple alternate groupsizes combinations upon a Number Table and performing a similar type of ROW andCOLUMN analysis undertaken in that thread. Please see Table below:
FIGURE 1 – ROW
<tbody>
</tbody>
FIGURE 2 - COLUMN
<tbody>
</tbody>
I am looking at number pools of either 35 or 45numbers in any given Number Table.
Within this Table I would like to produce an output based on an alternate number grouping criteria and copied to a differentarea of the worksheet in a row by row basis as per the above Table. Please alsosee this ALTERNATE LISTING below: This Listing provides all possible forwardand reverse alternate number groupings for each of the number pool sizes of 35and 45. As such I would like to choose any such alternating number combination fromthat list and extract output based on that combination. The first columns in eachNumber Pool listing is the first of the alternate grouping number size, thesecond column being the second grouping number size. For eg in the 35 NumberPool List the first row shows the alternate number grouping of (1/6).
ALTERNATE NUMBER GROUP LISTING
<tbody>
</tbody>
For example from Table 1 above I have a pool of45 numbers and I would like to group these numbers using an alternate groupingcombination of say (1/8) and applying a (Horizontal) ROW type Analysis.
What I would end up with is a Summary Output asper Table 1 above listing those results, as you can see from this example all (1)and (8) number groupings have been copied over from that Table and listed intheir respective columns.
Variation : 1 – Reverse position of alternate group number
In this variation I simply would like to change andreverse the sequence of the alternate group combination, taking from the exampleabove of the (1/8) alternate grouping I would change the sequence to start witha size 8 grouping i.e (8/1). Therefore the first grouping would be 8 numbers andthe second grouping would be 1 number etc. This would also be applied in aVertical and Horizontal fashion, please see screenshot below.
REVERSE ANALYSIS
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
CONDITIONAL FORMATTING
I am not sure if this is possible but alsocreating a conditional format rule to highlight the alternate numbers fromtheir respective alternate number grouping into two separate colours. So fromthe above example all numbers grouped in 1’s can be colour coded as yellow andall numbers grouped in 8’s can be colour coded as blue.
Thanking You and looking forward to your responses
COTECH_10
Hi All,
Extending from another thread posted Re: Number SelectionOct 24th, 2019 I am looking to analyze multiple alternate groupsizes combinations upon a Number Table and performing a similar type of ROW andCOLUMN analysis undertaken in that thread. Please see Table below:
FIGURE 1 – ROW
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | SUMMARY OUTPUT - Row | |||||||||||||||||||
2 | 1 | 56 | 2 | 51 | 5 | 7 | 1 | |||||||||||||
3 | 100 | 4 | 71 | 5 | 24 | 1 | ||||||||||||||
4 | 19 | 12 | 26 | 5 | ||||||||||||||||
5 | 323 | 73 | 8 | 109 | ||||||||||||||||
6 | 43 | 109 | 41 | 14 | ||||||||||||||||
7 | 9 | 25 | 12 | 17 | ||||||||||||||||
8 | 88 | 16 | ||||||||||||||||||
9 | 20 | 105 | 14 | 77 | ||||||||||||||||
10 | 7 | 25 | 8 | |||||||||||||||||
11 | 91 | 56 | 2 | 51 | 5 | 7 | 100 | 4 | 71 | |||||||||||
12 | 90 | 98 | 24 | 19 | 12 | 26 | 323 | 73 | 8 | 43 | ||||||||||
13 | 41 | 9 | 25 | 12 | 88 | 16 | 20 | 105 | ||||||||||||
14 | 6 | 45 | etc | |||||||||||||||||
15 | 17 | etc | ||||||||||||||||||
16 | 55 | etc | ||||||||||||||||||
17 | 50 | |||||||||||||||||||
18 | 2 | 37 | ||||||||||||||||||
19 | 3 | 55 | ||||||||||||||||||
20 | 17 | 99 |
<tbody>
</tbody>
alt_ROW
FIGURE 2 - COLUMN
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | SUMMARY OUTPUT - Columnar | ||||||||||||||||||||
2 | 1 | 56 | 2 | 51 | 5 | 7 | 1 | ||||||||||||||
3 | 100 | 4 | 71 | 5 | 24 | 1 | |||||||||||||||
4 | 19 | 12 | 26 | 88 | |||||||||||||||||
5 | 323 | 73 | 8 | 26 | |||||||||||||||||
6 | 43 | 109 | 41 | 105 | |||||||||||||||||
7 | 9 | 25 | 12 | 2 | |||||||||||||||||
8 | 88 | 16 | |||||||||||||||||||
9 | 20 | 105 | 14 | 77 | |||||||||||||||||
10 | 7 | 25 | |||||||||||||||||||
11 | 91 | 8 | |||||||||||||||||||
12 | 90 | 98 | 100 | 323 | 9 | 20 | 6 | 17 | 4 | 19 | |||||||||||
13 | 7 | 56 | 43 | 2 | 109 | 55 | 71 | 73 | |||||||||||||
14 | 6 | 45 | 51 | 12 | 25 | 5 | 8 | 12 | 14 | 17 | |||||||||||
15 | 17 | etc | |||||||||||||||||||
16 | 55 | etc | |||||||||||||||||||
17 | 50 | etc | |||||||||||||||||||
18 | 2 | 37 | |||||||||||||||||||
19 | 3 | 55 | |||||||||||||||||||
20 | 17 | 99 |
<tbody>
</tbody>
alt_COL
I am looking at number pools of either 35 or 45numbers in any given Number Table.
Within this Table I would like to produce an output based on an alternate number grouping criteria and copied to a differentarea of the worksheet in a row by row basis as per the above Table. Please alsosee this ALTERNATE LISTING below: This Listing provides all possible forwardand reverse alternate number groupings for each of the number pool sizes of 35and 45. As such I would like to choose any such alternating number combination fromthat list and extract output based on that combination. The first columns in eachNumber Pool listing is the first of the alternate grouping number size, thesecond column being the second grouping number size. For eg in the 35 NumberPool List the first row shows the alternate number grouping of (1/6).
ALTERNATE NUMBER GROUP LISTING
A | B | C | D | E | |
---|---|---|---|---|---|
1 | 35 Number | Pool | 45 Number | Pool | |
2 | 1 | 6 | 1 | 8 | |
3 | 6 | 1 | 8 | 1 | |
4 | 2 | 5 | 2 | 7 | |
5 | 5 | 2 | 7 | 2 | |
6 | 3 | 4 | 3 | 6 | |
7 | 4 | 3 | 6 | 3 | |
8 | 1 | 4 | 4 | 5 | |
9 | 4 | 1 | 5 | 4 | |
10 | 2 | 3 | 1 | 4 | |
11 | 3 | 2 | 4 | 1 | |
12 | 2 | 3 | |||
13 | 3 | 2 | |||
14 | 1 | 14 | |||
15 | 14 | 1 | |||
16 | 2 | 13 | |||
17 | 13 | 2 | |||
18 | 3 | 12 | |||
19 | 12 | 3 | |||
20 | 4 | 11 | |||
21 | 11 | 4 | |||
22 | 5 | 10 | |||
23 | 10 | 5 | |||
24 | 6 | 9 | |||
25 | 9 | 6 | |||
26 | 7 | 8 | |||
27 | 8 | 7 | |||
28 | 1 | 2 | |||
29 | 2 | 1 |
<tbody>
</tbody>
extra (2)
For example from Table 1 above I have a pool of45 numbers and I would like to group these numbers using an alternate groupingcombination of say (1/8) and applying a (Horizontal) ROW type Analysis.
What I would end up with is a Summary Output asper Table 1 above listing those results, as you can see from this example all (1)and (8) number groupings have been copied over from that Table and listed intheir respective columns.
Variation : 1 – Reverse position of alternate group number
In this variation I simply would like to change andreverse the sequence of the alternate group combination, taking from the exampleabove of the (1/8) alternate grouping I would change the sequence to start witha size 8 grouping i.e (8/1). Therefore the first grouping would be 8 numbers andthe second grouping would be 1 number etc. This would also be applied in aVertical and Horizontal fashion, please see screenshot below.
REVERSE ANALYSIS
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | SUMMARY OUTPUT - Variation 1 - Reverse | ||||||||||||||||||||
2 | 1 | 56 | 2 | 51 | 5 | 7 | 8 | ||||||||||||||
3 | 100 | 4 | 71 | 5 | 24 | 1 | 56 | 2 | 51 | 5 | 7 | 100 | 4 | ||||||||
4 | 19 | 12 | 26 | 5 | 24 | 19 | 12 | 26 | 323 | 73 | 8 | ||||||||||
5 | 323 | 73 | 8 | 109 | 41 | 9 | 25 | 12 | 88 | 16 | 20 | ||||||||||
6 | 43 | 109 | 41 | etc | |||||||||||||||||
7 | 9 | 25 | 12 | etc | |||||||||||||||||
8 | 88 | 16 | etc | ||||||||||||||||||
9 | 20 | 105 | 14 | 77 | |||||||||||||||||
10 | 7 | 25 | 1 | ||||||||||||||||||
11 | 91 | 71 | |||||||||||||||||||
12 | 90 | 98 | 43 | ||||||||||||||||||
13 | 105 | ||||||||||||||||||||
14 | 6 | 45 | 45 | ||||||||||||||||||
15 | 17 | 99 | |||||||||||||||||||
16 | 55 | ||||||||||||||||||||
17 | 50 | ||||||||||||||||||||
18 | 2 | 37 | |||||||||||||||||||
19 | 3 | 55 | |||||||||||||||||||
20 | 17 | 99 |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
var_ROW
CONDITIONAL FORMATTING
I am not sure if this is possible but alsocreating a conditional format rule to highlight the alternate numbers fromtheir respective alternate number grouping into two separate colours. So fromthe above example all numbers grouped in 1’s can be colour coded as yellow andall numbers grouped in 8’s can be colour coded as blue.
Thanking You and looking forward to your responses
COTECH_10