Matrix table...?

[sezuh]

hi,
thanks for all the help i had before much obliged.
what i need now is,how to create a Matrix table.i have a list in colum "A"
and i need to count each number occurs with other numbers,table have to be dynamic so when i add more rows to the list should change accordingly,is that possible?matrix table size up to 66 number each side.
here is small example;
Sheet4

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 11pt; FONT-FAMILY: Calibri,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 87px"><COL style="WIDTH: 45px"><COL style="WIDTH: 33px"><COL style="WIDTH: 33px"><COL style="WIDTH: 33px"><COL style="WIDTH: 33px"><COL style="WIDTH: 33px"><COL style="WIDTH: 33px"><COL style="WIDTH: 33px"><COL style="WIDTH: 33px"><COL style="WIDTH: 33px"><COL style="WIDTH: 33px"><COL style="WIDTH: 33px"><COL style="WIDTH: 33px"><COL style="WIDTH: 33px"><COL style="WIDTH: 33px"><COL style="WIDTH: 33px"><COL style="WIDTH: 33px"><COL style="WIDTH: 33px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>A</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></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD>list</TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">4</TD><TD style="TEXT-ALIGN: right">5</TD><TD style="TEXT-ALIGN: right">6</TD><TD style="TEXT-ALIGN: right">7</TD><TD style="TEXT-ALIGN: right">8</TD><TD style="TEXT-ALIGN: right">9</TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">11</TD><TD style="TEXT-ALIGN: right">12</TD><TD style="TEXT-ALIGN: right">13</TD><TD style="TEXT-ALIGN: right">14</TD><TD style="TEXT-ALIGN: right">15</TD><TD style="TEXT-ALIGN: right">16</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">1 9 10 11</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="TEXT-ALIGN: right">1</TD><TD style="COLOR: #0066cc">X</TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">2</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">1 3 9 11</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="TEXT-ALIGN: right">2</TD><TD> </TD><TD style="COLOR: #0066cc">X</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">2 8 14 15</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD style="COLOR: #0066cc">X</TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">3 4 6 16</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="TEXT-ALIGN: right">4</TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD style="COLOR: #0066cc">X</TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">5 7 12 13</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="TEXT-ALIGN: right">5</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="COLOR: #0066cc">X</TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="TEXT-ALIGN: right">6</TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD style="COLOR: #0066cc">X</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="TEXT-ALIGN: right">7</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD style="COLOR: #0066cc">X</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="TEXT-ALIGN: right">8</TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="COLOR: #0066cc">X</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="TEXT-ALIGN: right">9</TD><TD style="TEXT-ALIGN: right">2</TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="COLOR: #0066cc">X</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">2</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD style="COLOR: #0066cc">X</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="TEXT-ALIGN: right">11</TD><TD style="TEXT-ALIGN: right">2</TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="COLOR: #0066cc">X</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="TEXT-ALIGN: right">12</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="COLOR: #0066cc">X</TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="TEXT-ALIGN: right">13</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD style="COLOR: #0066cc">X</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="TEXT-ALIGN: right">14</TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="COLOR: #0066cc">X</TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="TEXT-ALIGN: right">15</TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD style="COLOR: #0066cc">X</TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="TEXT-ALIGN: right">16</TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD style="TEXT-ALIGN: right">1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD style="COLOR: #0066cc">X</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">18</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS"> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR></TBODY></TABLE>



thanks and kind regards
Sezuh

 

[sezuh]

Thank you very very much Peter ,for your time and brilliant
solution, much appreciated....
with your help this tread now is closed...
Have a very good day.
Sezuh

 

[MickG]

I cant seem to duplicate your error.
Running the code on your latest Number list i get this:-

If you happy with Peter's solution, I'll leave it there!!!

[COLOR="RoyalBlue"][B]Row No [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(A)         [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(B) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(C) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(D) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(E) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(F) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(G) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(H) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(I) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(J) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(K) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(L) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(M) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(N) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(O) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(P) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(Q) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(R) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(S) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(T) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(U) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(V) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(W) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(X) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(Y) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(Z) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(AA) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(AB) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(AC) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(AD) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(AE) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(AF) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(AG) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(AH) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(AI) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(AJ) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(AK) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(AL) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(AM) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(AN) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(AO) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(AP) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(AQ) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(AR) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(AS) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(AT) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(AU) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(AV) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(AW) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(AX) [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(AY) [/B][/COLOR]
1.      List                            1       2       3       4       5       6       7       8       9       10      11      12      13      14      15      16      17      18      19      20      21      22      23      24       25       26       27       28       29       30       31       32       33       34       35       36       37       38       39       40       41       42       43       44       45       46       47       48      
2.      08 18 27 28 46          1       X                                       1                                               1               1                                                                                        1                                   1                                   1        1                 1                                                                                                                   
3.      17 30 33 34 38          2               X       1                               1               1                                                       1       1                               2                                                                                      1                                                                                                                                                                
4.      17 18 24 29 35          3               1       X               1               1       1       1                                                               1       1                       1                                                                                                                                                                                                                                                       
5.      02 03 07 17 21          4                               X                                                                                                                                                                                                                                                         1                                                     1        1                          1                                           
6.      01 06 12 29 36          5                       1               X       1               1       1                                                                       2                                                                                                                                                           1                                                                       1                                           
7.      06 15 27 32 37          6       1                               1       X               1                               1                       1               1       2                       1               1                         1        1                 1                          2                                   2        1                 1                                            1                                           
8.      05 06 18 36 44          7               1       1                               X                               1               1       1                       1                               1                                                                                                                                                     1                                                                                                 
9.      03 05 08 09 18          8                       1               1       1               X       1                                                               1       2                       1                                                  1        1                                                                                                  1                                                              1                         
10.     04 34 40 41 44          9               1       1               1                       1       X                                                       1               1                       1                                                                                      1                                                                                                                                                                
11.     01 14 25 33 34          10                                                                              X                                               1       1                               1                                                                                                                                                              1                                                                                        
12.     06 08 17 21 39          11                                                      1                               X               1       1                                                                                                                                                                                                             1                                                                                                 
13.     07 11 13 14 38          12      1                                       1                                               X               1                                                                                                                            1                          1                                   1                                                                       1                                   1       
14.     12 14 32 44 48          13                                                      1                               1               X       1                                                                                                                                                                                                             1                                                                                                 
15.     10 16 17 21 39          14      1                                               1                               1       1       1       X                                                                                        1                                                              1        1        1                                   1                                                     1                                   1       
16.     02 09 16 21 31          15                                              1                                                                       X                                                                                                  1                                            1                                            1                                                                                                          
17.     06 18 23 26 32          16              1                                                       1       1                                               X       1                               2                                                                                      1                                                                       1                                                                                        
18.                             17              1       1                       1       1       1               1                                               1       X       1                       3                       1                                            1        1                          1        1        1                          1        2                                                                                        
19.                             18                      1               2       2               2       1                                                               1       X                                       1       1                 1        1        1        1                          1                          1        1                                                                       1                 1                         
20.                             19                                                                                                                                                                                                                                                                                                                                                                                                                              
21.                             20                                                                                                                                                                                                                                                                                                                                                                                                                              
22.                             21              2       1                       1       1       1       1       1                                               2       3                               X                                                                                      1                                                                       2                                                                                        
23.                             22                                                                                                                                                                                                                                                                                                                                                                                                                              
24.                             23                                              1                                                                                               1                                       X                         1                                                     1                                                                                                                                                       
25.                             24                                                                                                                                      1       1                                               X                                            1                                                     1                                                                                                                            
26.                             25      1                                                                                                       1                                                                                        X                                                                       1        1                                                                                                                                     
27.                             26                                              1                                                                                               1                                       1                         X                                                     1                                                                                                                                                       
28.                             27                                              1               1                                                       1                       1                                                                          X        1                                   1                                            1                                                                                1                         
29.                             28                                                              1                                                                               1                                                                          1        X                                                                                                                                                                 1                         
30.                             29      1                                       1                                               1                                       1       1                                               1                                            X                                                     1        1                                                                                                                   
31.                             30                                                                                                                                      1                                                                                                             X                          1        1                                   1                                                                                                 
32.                             31              1                                                       1                                                       1                                       1                                                                                      X                                                                                                                                                                
33.                             32                                              2                                               1               1       1                       1                                       1                         1        1                                            X                                            1                                                              1                                   1       
34.                             33      1                                                                                                       1                       1                                                                1                                            1                          X        2                                   1                                                                                                 
35.                             34      1                       1                                                                               1                       1                                                                1                                            1                          2        X                                   1                 1        1                          1                                           
36.                             35                                                                                                                                      1       1                                               1                                            1                                                     X                                                                                                                            
37.                             36      1                               1       2                                               1                                               1                                                                                            1                                                              X                                                                       1                                           
38.                             37                                              1                                                                       1                                                                                                  1                                            1                                            X                                                                                                          
39.                             38                                                      1                               1               1       1                       1                                                                                                             1                          1        1                                   X                                                                                                 
40.                             39                                              1               1               1                                               1       2                               2                                                                                                                                                              X                                                                                        
41.                             40                              1                                                                                                                                                                                                                                                         1                                                     X        1                          1                                           
42.                             41                              1                                                                                                                                                                                                                                                         1                                                     1        X                          1                                           
43.                             42                                                                                                                                                                                                                                                                                                                                                                                                                              
44.                             43                                                                                                                                                                                                                                                                                                                                                                                                                              
45.                             44                              1       1       1                                               1               1                               1                                                                                                                       1                 1                 1                                   1        1                          X                                   1       
46.                             45                                                                                                                                                                                                                                                                                                                                                                                                                              
47.                             46                                                              1                                                                               1                                                                          1        1                                                                                                                                                                 X                         
48.                             47                                                                                                                                                                                                                                                                                                                                                                                                                              
49.                             48                                                                                              1               1                                                                                                                                                       1                                                                                                           1                                   X

Regards Mick

 

[sezuh]

Hi Mick,
thanks for your response,your code gives me error on two criteria ,
1)when there are more than 5 numbers in a string,
2) when the number string contain single character ie;"1 2 3 ......9"
but when they are double character and less than six numbers in a string
the code works.
Anyway thanks for your invaluable time and effort.
Regards
Sezuh