Re: Number Selection - Extension

C

cotech_10

Board Regular
Joined
Sep 11, 2010
Messages
135
Office Version
  1. 2016
Platform
  1. Windows
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

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
SUMMARY OUTPUT - Row
etc
etc
etc

<tbody>
[TD="align: center"]1
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFF00, align: right"]1
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]56
[/TD]
[TD="bgcolor: #BDD7EE, align: right"]2
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]51
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]5
[/TD]
[TD="bgcolor: #BDD7EE, align: right"]7
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]100
[/TD]
[TD="bgcolor: #BDD7EE, align: right"]4
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]71
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFF00, align: right"]5
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]24
[/TD]
[TD="align: right"][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]19
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]12
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]26
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]5
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]323
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]73
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]8
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]109
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]43
[/TD]
[TD="bgcolor: #FFFF00, align: right"]109
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]41
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]14
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]9
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]25
[/TD]
[TD="bgcolor: #BDD7EE, align: right"]12
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]17
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]88
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]16
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]20
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]105
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFF00, align: right"]14
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]77
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]7
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]25
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]8
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]91
[/TD]
[TD="align: right"][/TD]
[TD="align: right"]56
[/TD]
[TD="align: right"]2
[/TD]
[TD="align: right"]51
[/TD]
[TD="align: right"]5
[/TD]
[TD="align: right"]7
[/TD]
[TD="align: right"]100
[/TD]
[TD="align: right"]4
[/TD]
[TD="align: right"]71
[/TD]

[TD="align: center"]12
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]90
[/TD]
[TD="bgcolor: #BDD7EE, align: right"]98
[/TD]
[TD="align: right"][/TD]
[TD="align: right"]24
[/TD]
[TD="align: right"]19
[/TD]
[TD="align: right"]12
[/TD]
[TD="align: right"]26
[/TD]
[TD="align: right"]323
[/TD]
[TD="align: right"]73
[/TD]
[TD="align: right"]8
[/TD]
[TD="align: right"]43
[/TD]

[TD="align: center"]13
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]41
[/TD]
[TD="align: right"]9
[/TD]
[TD="align: right"]25
[/TD]
[TD="align: right"]12
[/TD]
[TD="align: right"]88
[/TD]
[TD="align: right"]16
[/TD]
[TD="align: right"]20
[/TD]
[TD="align: right"]105
[/TD]

[TD="align: center"]14
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]6
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]45
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFF00, align: right"]17
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]55
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]50
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]2
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]37
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]19
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]3
[/TD]
[TD="bgcolor: #BDD7EE, align: right"]55
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]20
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]17
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]99
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</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
SUMMARY OUTPUT - Columnar
etc
etc
etc

<tbody>
[TD="align: center"]1
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFF00, align: right"]1
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]56
[/TD]
[TD="bgcolor: #BDD7EE, align: right"]2
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]51
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]5
[/TD]
[TD="bgcolor: #BDD7EE, align: right"]7
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]1
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]100
[/TD]
[TD="bgcolor: #BDD7EE, align: right"]4
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]71
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]5
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]24
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]19
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]12
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFF00, align: right"]26
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]88
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]323
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]73
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]8
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]26
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]43
[/TD]
[TD="bgcolor: #BDD7EE, align: right"]109
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]41
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]105
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]9
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]25
[/TD]
[TD="bgcolor: #BDD7EE, align: right"]12
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]2
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFF00, align: right"]88
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]16
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]20
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFF00, align: right"]105
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]14
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]77
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]7
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]25
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]91
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]8
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]90
[/TD]
[TD="bgcolor: #BDD7EE, align: right"]98
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]100
[/TD]
[TD="align: right"]323
[/TD]
[TD="align: right"]9
[/TD]
[TD="align: right"]20
[/TD]
[TD="align: right"]6
[/TD]
[TD="align: right"]17
[/TD]
[TD="align: right"]4
[/TD]
[TD="align: right"]19
[/TD]

[TD="align: center"]13
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]7
[/TD]
[TD="align: right"]56
[/TD]
[TD="align: right"]43
[/TD]
[TD="align: right"]2
[/TD]
[TD="align: right"]109
[/TD]
[TD="align: right"]55
[/TD]
[TD="align: right"]71
[/TD]
[TD="align: right"]73
[/TD]

[TD="align: center"]14
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]6
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]45
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]51
[/TD]
[TD="align: right"]12
[/TD]
[TD="align: right"]25
[/TD]
[TD="align: right"]5
[/TD]
[TD="align: right"]8
[/TD]
[TD="align: right"]12
[/TD]
[TD="align: right"]14
[/TD]
[TD="align: right"]17
[/TD]

[TD="align: center"]15
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]17
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]55
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]50
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFF00, align: right"]2
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]37
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]19
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]3
[/TD]
[TD="bgcolor: #BDD7EE, align: right"]55
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]20
[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]17
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]99
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</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
35 Number
Pool
45 Number
Pool

<tbody>
[TD="align: center"]1
[/TD]

[TD="align: right"][/TD]

[TD="align: center"]2
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]6
[/TD]
[TD="align: right"][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]8
[/TD]

[TD="align: center"]3
[/TD]
[TD="align: right"]6
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"][/TD]
[TD="align: right"]8
[/TD]
[TD="align: right"]1
[/TD]

[TD="align: center"]4
[/TD]
[TD="align: right"]2
[/TD]
[TD="align: right"]5
[/TD]
[TD="align: right"][/TD]
[TD="align: right"]2
[/TD]
[TD="align: right"]7
[/TD]

[TD="align: center"]5
[/TD]
[TD="align: right"]5
[/TD]
[TD="align: right"]2
[/TD]
[TD="align: right"][/TD]
[TD="align: right"]7
[/TD]
[TD="align: right"]2
[/TD]

[TD="align: center"]6
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]4
[/TD]
[TD="align: right"][/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]6
[/TD]

[TD="align: center"]7
[/TD]
[TD="align: right"]4
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6
[/TD]
[TD="align: right"]3
[/TD]

[TD="align: center"]8
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]4
[/TD]
[TD="align: right"][/TD]
[TD="align: right"]4
[/TD]
[TD="align: right"]5
[/TD]

[TD="align: center"]9
[/TD]
[TD="align: right"]4
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"][/TD]
[TD="align: right"]5
[/TD]
[TD="align: right"]4
[/TD]

[TD="align: center"]10
[/TD]
[TD="align: right"]2
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]4
[/TD]

[TD="align: center"]11
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]2
[/TD]
[TD="align: right"][/TD]
[TD="align: right"]4
[/TD]
[TD="align: right"]1
[/TD]

[TD="align: center"]12
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]2
[/TD]
[TD="align: right"]3
[/TD]

[TD="align: center"]13
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]2
[/TD]

[TD="align: center"]14
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]14
[/TD]

[TD="align: center"]15
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]14
[/TD]
[TD="align: right"]1
[/TD]

[TD="align: center"]16
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]2
[/TD]
[TD="align: right"]13
[/TD]

[TD="align: center"]17
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]13
[/TD]
[TD="align: right"]2
[/TD]

[TD="align: center"]18
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]12
[/TD]

[TD="align: center"]19
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]12
[/TD]
[TD="align: right"]3
[/TD]

[TD="align: center"]20
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]4
[/TD]
[TD="align: right"]11
[/TD]

[TD="align: center"]21
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]11
[/TD]
[TD="align: right"]4
[/TD]

[TD="align: center"]22
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]5
[/TD]
[TD="align: right"]10
[/TD]

[TD="align: center"]23
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]10
[/TD]
[TD="align: right"]5
[/TD]

[TD="align: center"]24
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6
[/TD]
[TD="align: right"]9
[/TD]

[TD="align: center"]25
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]9
[/TD]
[TD="align: right"]6
[/TD]

[TD="align: center"]26
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]7
[/TD]
[TD="align: right"]8
[/TD]

[TD="align: center"]27
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]8
[/TD]
[TD="align: right"]7
[/TD]

[TD="align: center"]28
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]2
[/TD]

[TD="align: center"]29
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]2
[/TD]
[TD="align: right"]1
[/TD]

</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


ABCDEFGHIJKLMNOPQRSTU
SUMMARY OUTPUT - Variation 1 - Reverse
etc
etc
etc

<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>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]56[/TD]
[TD="bgcolor: #BDD7EE, align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]51[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]5[/TD]
[TD="bgcolor: #BDD7EE, align: right"]7[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]8[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]100[/TD]
[TD="bgcolor: #BDD7EE, align: right"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFF00, align: right"]71[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]24[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]51[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]4[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]19[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]12[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]26[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]323[/TD]
[TD="align: right"]73[/TD]
[TD="align: right"]8[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]323[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]73[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]8[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]109[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]88[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]20[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFF00, align: right"]43[/TD]
[TD="bgcolor: #BDD7EE, align: right"]109[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]41[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]9[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]25[/TD]
[TD="bgcolor: #BDD7EE, align: right"]12[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]88[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]20[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFF00, align: right"]105[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]14[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]77[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]7[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]25[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]91[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]71[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]90[/TD]
[TD="bgcolor: #BDD7EE, align: right"]98[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]43[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]105[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFF00, align: right"]45[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]45[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]17[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]99[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]55[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]50[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]2[/TD]
[TD="bgcolor: #BDD7EE, align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]37[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]3[/TD]
[TD="bgcolor: #BDD7EE, align: right"]55[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]20[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #BDD7EE, align: right"]17[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="bgcolor: #FFFF00, align: right"]99[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</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
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Sort by date Sort by votes
Re: Number Selection - Extension

That seems like a fairly big ask ... but if I have understood correctly, may be possible.

In fact everything below depends on IF I have understood correctly. :eek:


cotech_10 said:
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.
Click to expand...
This part would be simple enough using standard CF. For example, for horizontal analysis of a 45 group, with a grouping criteria of 2/7 it would be this

<b>Pattern</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:8pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td><td >H</td><td >I</td><td >J</td><td >K</td><td >L</td><td >M</td><td >N</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="background-color:#ffff00; font-family:Calibri; text-align:right; ">1</td><td style="font-family:Calibri; "> </td><td style="background-color:#ffff00; font-family:Calibri; text-align:right; ">56</td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">2</td><td style="font-family:Calibri; "> </td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">51</td><td style="font-family:Calibri; "> </td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">5</td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">7</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; text-align:center; ">2</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">100</td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">4</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">71</td><td style="font-family:Calibri; "> </td><td style="background-color:#ffff00; font-family:Calibri; text-align:right; ">5</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#ffff00; font-family:Calibri; text-align:right; ">24</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-size:10pt; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="font-family:Calibri; "> </td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">19</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">12</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">26</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-size:10pt; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">323</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">73</td><td style="font-family:Calibri; "> </td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">8</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-size:10pt; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">43</td><td style="background-color:#ffff00; font-family:Calibri; text-align:right; ">109</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#ffff00; font-family:Calibri; text-align:right; ">41</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-size:10pt; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">9</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">25</td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">12</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-size:10pt; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="font-family:Calibri; "> </td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">88</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">16</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">20</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">105</td><td style="font-family:Calibri; "> </td><td style="background-color:#ffff00; font-family:Calibri; text-align:right; ">14</td><td style="font-family:Calibri; "> </td><td style="background-color:#ffff00; font-family:Calibri; text-align:right; ">77</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="font-family:Calibri; "> </td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">7</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">25</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; text-align:center; ">7</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">91</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-size:10pt; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">90</td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">98</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-size:10pt; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-size:10pt; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">6</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">45</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-size:10pt; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#ffff00; font-family:Calibri; text-align:right; ">17</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-size:10pt; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#ffff00; font-family:Calibri; text-align:right; ">55</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">50</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">2</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">37</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">3</td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">55</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">17</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#bdd7ee; font-family:Calibri; text-align:right; ">99</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td></tr></table><br /><table style="font-family:Arial; font-size:10pt; background-color:#fffcf9; border-style: groove ;border-color:#ff0000"><tr><td ><b>Conditional formatting </b></td></tr><tr><td ><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial; font-size:10pt; padding-left:2pt; padding-right:2pt; "><tr><td >Cell</td><td >Nr.: / Condition</td><td >Format</td></tr><tr><td >B2</td><td >1. / Formula is =AND(B2<>"",MOD(COUNT($B$1:$K1)+COUNT($B2:B2)-1,$N$2+$N$10)<$N$2)</td><td style="background-color:#ffff00; ">Abc</td></tr><tr><td >B2</td><td >2. / Formula is =B2<>""</td><td style="background-color:#bdd7ee; ">Abc</td></tr></table></td></tr></table>

However, with possible grouping criteria of 1/8 or 8/1 or 2/7 or 13/2 etc I think a worksheet formula would be becoming too complex so I think a switch back to vba would be the way to go. See next post.
 
Upvote 0
Re: Number Selection - Extension

For a macro approach try this code. At the moment I have specified the data 'shape (rows x columns), grouping criteria (1/8 etc) & Horizontal or Vertical analysis (H/V) within the code (in the Const lines near the top). I'm not sure what you intended for that. Note also that the code is doing the colouring now, not CF.

Rich (BB code): 
Sub Make_Groups()
  Dim a As Variant, b As Variant, c As Variant, d As Variant, RowCol As Variant, SubGroups As Variant
  Dim GrpSize As Long, i As Long, j As Long, k As Long, w As Long, x As Long, y As Long, z As Long
  Dim rData As Range
  
  Const DataSize As String = "19x10"
  Const SubGrpSize As String = "2+7"
  Const AnalysisDirection As String = "H" 'Use H or V
  
  RowCol = Split(DataSize, "x")
  SubGroups = Split(SubGrpSize, "+")
  GrpSize = Evaluate(SubGrpSize)
  Set rData = Range("B2").Resize(RowCol(0), RowCol(1))
  a = IIf(AnalysisDirection = "H", rData.Value, Application.Transpose(rData.Value))
  ReDim b(1 To UBound(a), 1 To UBound(a, 2))
  ReDim c(1 To UBound(a), 1 To SubGroups(0))
  ReDim d(1 To UBound(a), 1 To SubGroups(1))
  w = 1
  y = 1
  For i = 1 To UBound(a)
    For j = 1 To UBound(a, 2)
      If Len(a(i, j)) Then
        k = k + 1
        If (k - 1) Mod GrpSize < SubGroups(0) Then
          x = x + 1
          If x > SubGroups(0) Then
            x = 1
            w = w + 1
          End If
          c(w, x) = a(i, j)
          b(i, j) = 1
        Else
          z = z + 1
          If z > SubGroups(1) Then
            z = 1
            y = y + 1
          End If
          d(y, z) = a(i, j)
          b(i, j) = "x"
        End If
      End If
    Next j
  Next i
  With rData
    .Value = IIf(AnalysisDirection = "H", b, Application.Transpose(b))
    .SpecialCells(xlConstants, xlNumbers).Interior.Color = 65535
    .SpecialCells(xlConstants, xlTextValues).Interior.Color = 15652797
    .Value = IIf(AnalysisDirection = "H", a, Application.Transpose(a))
  End With
  With rData.Offset(, RowCol(1) + 2)
    .Cells(1, 1).Value = SubGroups(0)
    .Cells(2, 1).Resize(w, SubGroups(0)).Value = c
    .Cells(w + 3, 1).Value = SubGroups(1)
    .Cells(w + 4, 1).Resize(y, SubGroups(1)).Value = d
  End With
End Sub


Here is my result for a horizontal analysis with a 2/7 grouping.

<b>Pattern H</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:8pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /><col style="width:29px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td><td >H</td><td >I</td><td >J</td><td >K</td><td >L</td><td >M</td><td >N</td><td >O</td><td >P</td><td >Q</td><td >R</td><td >S</td><td >T</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="background-color:#ffff00; font-family:Calibri; text-align:right; ">1</td><td style="font-family:Calibri; "> </td><td style="background-color:#ffff00; font-family:Calibri; text-align:right; ">56</td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">2</td><td style="font-family:Calibri; "> </td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">51</td><td style="font-family:Calibri; "> </td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">5</td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">7</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; text-align:right; ">2</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">100</td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">4</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">71</td><td style="font-family:Calibri; "> </td><td style="background-color:#ffff00; font-family:Calibri; text-align:right; ">5</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#ffff00; font-family:Calibri; text-align:right; ">24</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; text-align:right; ">1</td><td style="font-family:Calibri; text-align:right; ">56</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="font-family:Calibri; "> </td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">19</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">12</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">26</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; text-align:right; ">5</td><td style="font-family:Calibri; text-align:right; ">24</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">323</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">73</td><td style="font-family:Calibri; "> </td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">8</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; text-align:right; ">109</td><td style="font-family:Calibri; text-align:right; ">41</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">43</td><td style="background-color:#ffff00; font-family:Calibri; text-align:right; ">109</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#ffff00; font-family:Calibri; text-align:right; ">41</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; text-align:right; ">14</td><td style="font-family:Calibri; text-align:right; ">77</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">9</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">25</td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">12</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; text-align:right; ">17</td><td style="font-family:Calibri; text-align:right; ">55</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="font-family:Calibri; "> </td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">88</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">16</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">20</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">105</td><td style="font-family:Calibri; "> </td><td style="background-color:#ffff00; font-family:Calibri; text-align:right; ">14</td><td style="font-family:Calibri; "> </td><td style="background-color:#ffff00; font-family:Calibri; text-align:right; ">77</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; text-align:right; ">7</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="font-family:Calibri; "> </td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">7</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">25</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; text-align:right; ">2</td><td style="font-family:Calibri; text-align:right; ">51</td><td style="font-family:Calibri; text-align:right; ">5</td><td style="font-family:Calibri; text-align:right; ">7</td><td style="font-family:Calibri; text-align:right; ">100</td><td style="font-family:Calibri; text-align:right; ">4</td><td style="font-family:Calibri; text-align:right; ">71</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">91</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; text-align:right; ">19</td><td style="font-family:Calibri; text-align:right; ">12</td><td style="font-family:Calibri; text-align:right; ">26</td><td style="font-family:Calibri; text-align:right; ">323</td><td style="font-family:Calibri; text-align:right; ">73</td><td style="font-family:Calibri; text-align:right; ">8</td><td style="font-family:Calibri; text-align:right; ">43</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">90</td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">98</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; text-align:right; ">9</td><td style="font-family:Calibri; text-align:right; ">25</td><td style="font-family:Calibri; text-align:right; ">12</td><td style="font-family:Calibri; text-align:right; ">88</td><td style="font-family:Calibri; text-align:right; ">16</td><td style="font-family:Calibri; text-align:right; ">20</td><td style="font-family:Calibri; text-align:right; ">105</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; text-align:right; ">7</td><td style="font-family:Calibri; text-align:right; ">25</td><td style="font-family:Calibri; text-align:right; ">91</td><td style="font-family:Calibri; text-align:right; ">90</td><td style="font-family:Calibri; text-align:right; ">98</td><td style="font-family:Calibri; text-align:right; ">6</td><td style="font-family:Calibri; text-align:right; ">45</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">6</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">45</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; text-align:right; ">50</td><td style="font-family:Calibri; text-align:right; ">2</td><td style="font-family:Calibri; text-align:right; ">37</td><td style="font-family:Calibri; text-align:right; ">3</td><td style="font-family:Calibri; text-align:right; ">55</td><td style="font-family:Calibri; text-align:right; ">17</td><td style="font-family:Calibri; text-align:right; ">99</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#ffff00; font-family:Calibri; text-align:right; ">17</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#ffff00; font-family:Calibri; text-align:right; ">55</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">50</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">2</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">37</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">3</td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">55</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">17</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="background-color:#ccccff; font-family:Calibri; text-align:right; ">99</td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td><td style="font-family:Calibri; "> </td></tr></table>
 
Upvote 0
Re: Number Selection - Extension

Hi Peter,

Thank you once again for an amazing effort... great achievement...

That works perfectly......I was looking to see if you can get it to
work in a vertical direction..


Thanks and Regards


COTECH_10
 
Upvote 0
Re: Number Selection - Extension

cotech_10 said:
...I was looking to see if you can get it to
work in a vertical direction..
Click to expand...
..
Rich (BB code): 
Const AnalysisDirection As String = "H" 'Use H or V
 
Upvote 0
Re: Number Selection - Extension

Hi Peter,

Perfect..!!!!!!! Just so much in awe of what you have provided and the response time and quality..

I am very grateful indeed..:):pray:
 
Upvote 0
Re: Number Selection - Extension

You're very welcome. It was an interesting problem. :)
 
Upvote 0
Re: Number Selection - Extension

Hi Peter,

Yes.... it was... :-)
 
Upvote 0
You must log in or register to reply here.

Similar threads

V
  • Solved
Creating a new filtered list from a dynamically created list based on previous numbers
Replies
6
Views
135
DanteAmor
DanteAmor
K
  • Question Question
Compress consecutive numbers
Replies
9
Views
385
Fuji
F
V
  • Question Question
Group list by batches based on multiple criteria
Replies
4
Views
418
hagia_sofia
hagia_sofia
V
  • Solved
Dynamic arrays, circular arguments and all I want to due is increment a previous number
Replies
3
Views
113
djclements
djclements
D
  • Question Question
Compile error: Wrong number of arguments or invalid property assignment
Replies
2
Views
74
daveyc18
D

Forum statistics

Threads
1,224,739
Messages
6,180,674
Members
452,993
Latest member
FDARYABEE

Share this page

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