VB code to re-arrange rows to complete the series of number?

[sezuh]

Hi,thank you for the wonderful help you provided me on my other treads.
I'm hoping i'll get some advice on this one.
I have a table "list"made of 57 rows and 5 column and assigned with string "array" of 4 numbers in each row.without touching column "A" i need a vb code to re-arrange the rows on "B:E columns" to get 1 to 20 numbers series in each row.i hope it's clear to understand.
here is the list and some result;
<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 11pt; FONT-FAMILY: Calibri,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><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></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD>LIST</TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 02 03 05</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 10 14 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 04 12 13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 07 09 10</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 11 12 19</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 02 04 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 10 16 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 04 14 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 08 11 12</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 11 14 15</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 02 06 08</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 11 13 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 04 16 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 08 14 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 11 17 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 02 07 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 11 14 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 04 05 07</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 08 15 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 13 14 19</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 02 09 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 12 14 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 04 08 10</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 08 09 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 15 19 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 02 10 11</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 13 15 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 04 09 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 09 14 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 08 12 14</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 02 12 13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 15 16 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 05 10 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 09 18 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 08 16 17</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 02 14 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 18 19 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 05 11 13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 10 15 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 08 18 19</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 02 16 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 03 10 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 05 15 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 11 12 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 08 09 11</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 03 13 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 03 11 12</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 05 18 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 11 18 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 09 12 16</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 03 16 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 03 13 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 05 06 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 12 14 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 09 13 18</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 03 19 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 03 15 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 05 08 12</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 13 17 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 09 14 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 03 04 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 03 17 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 05 09 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 13 19 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 09 15 17</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 03 06 10</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 03 04 06</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 06 11 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 14 16 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">08 10 13 17</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 03 07 12</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 03 07 09</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 06 12 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 06 10 12</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">08 10 14 19</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 03 08 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 03 08 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 06 13 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 06 11 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">08 10 16 18</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 03 09 11</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 04 10 12</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 06 15 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 06 14 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">08 11 13 14</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 04 10 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 04 14 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 06 07 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 06 16 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">08 11 16 19</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 04 11 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 04 17 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 06 08 09</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 06 07 09</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">08 12 13 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">21</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 04 13 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 04 05 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 07 10 11</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 07 10 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">08 12 15 16</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">22</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 04 05 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 04 07 11</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 07 13 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 07 11 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">08 14 15 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">23</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 04 06 07</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 04 08 13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 07 14 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 07 12 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">08 09 10 12</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">24</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 04 08 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 04 09 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 07 18 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 07 13 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">08 09 13 15</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">25</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 04 09 12</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 05 10 13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 07 08 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 07 17 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">08 09 17 18</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">26</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 05 10 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 05 11 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 08 11 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 08 10 11</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">08 09 19 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">27</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 05 11 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 05 12 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 08 13 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 08 13 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">09 10 11 13</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">28</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 05 12 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 05 14 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 08 17 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 08 14 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">09 10 14 16</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">29</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 05 16 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 05 06 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 09 10 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 08 15 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">09 10 18 19</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">30</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 05 06 13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 05 07 08</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 09 12 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 08 17 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">09 11 14 18</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">31</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 05 07 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 05 09 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 09 13 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 09 10 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">09 11 15 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">32</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 05 08 09</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 06 11 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 09 16 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 09 12 13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">09 11 17 19</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">33</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 06 11 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 06 12 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 10 11 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 09 15 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">09 12 14 15</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">34</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 06 12 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 06 13 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 10 13 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">05 09 16 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">09 12 17 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">35</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 06 14 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 06 17 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 10 17 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 10 11 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">09 13 16 17</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">36</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 06 15 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 06 07 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 11 13 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 10 13 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">10 11 12 14</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">37</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 06 09 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 06 09 10</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 11 14 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 10 16 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">10 11 15 17</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">38</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 07 10 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 07 10 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 12 16 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 10 17 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">10 11 19 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">39</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 07 11 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 07 12 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 12 18 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 12 13 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">10 12 15 19</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">40</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 07 14 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 07 13 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 13 15 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 13 15 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">10 12 18 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">41</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 07 08 13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 07 16 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 15 17 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 14 18 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">10 13 15 16</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">42</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 07 09 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 08 10 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 05 10 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 07 11 13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">10 14 17 18</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">43</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 08 10 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 08 11 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 05 12 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 07 12 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">11 12 13 15</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">44</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 08 11 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 08 12 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 05 13 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 07 15 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">11 12 16 18</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">45</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 08 12 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 08 15 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 05 15 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 07 17 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">11 13 16 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">46</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 08 16 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 08 09 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 05 06 08</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 07 08 10</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">11 14 16 17</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">47</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 09 10 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 09 11 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 05 09 11</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 08 11 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">11 15 18 19</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">48</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 09 13 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 09 12 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 06 10 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 08 12 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">12 13 14 16</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">49</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 09 15 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">02 09 13 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 06 11 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 08 13 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">12 13 17 19</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">50</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 10 12 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 10 12 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 06 12 14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 08 14 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">12 15 17 18</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">51</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 10 13 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 10 13 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 06 16 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 08 18 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">12 16 19 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">52</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 11 12 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 10 14 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 06 19 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 09 11 12</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">13 14 15 17</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">53</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 11 13 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 11 15 16</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 06 09 13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 09 14 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">13 14 18 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">54</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 12 14 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 11 17 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 07 12 15</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 09 15 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">13 16 18 19</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">55</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 13 17 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 12 14 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 07 13 17</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">06 09 16 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">14 15 16 18</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">56</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 14 15 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 12 15 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 07 14 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 10 12 13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">14 17 19 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">57</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 15 18 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 14 16 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 07 16 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 10 15 18</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">15 16 17 19</TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">58</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">01 17 18 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">03 04 11 19</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">04 07 08 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">07 10 16 20</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">16 17 18 20</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">59</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: #008080; FONT-FAMILY: Arial Unicode MS">EXPECTED RESULT</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">60</TD><TD style="FONT-WEIGHT: bold">01 02 03 05</TD><TD style="FONT-WEIGHT: bold">04 06 16 18</TD><TD style="FONT-WEIGHT: bold">07 10 12 13</TD><TD style="FONT-WEIGHT: bold">08 14 15 20</TD><TD style="FONT-WEIGHT: bold">09 11 17 19</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">61</TD><TD style="FONT-WEIGHT: bold">01 02 04 20</TD><TD style="FONT-WEIGHT: bold">03 05 10 16</TD><TD style="FONT-WEIGHT: bold">06 09 11 12</TD><TD style="FONT-WEIGHT: bold">07 08 18 19</TD><TD style="FONT-WEIGHT: bold">13 14 15 17</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">62</TD><TD style="FONT-WEIGHT: bold">01 02 06 08</TD><TD style="FONT-WEIGHT: bold">03 04 09 17</TD><TD style="FONT-WEIGHT: bold">05 07 11 16</TD><TD style="FONT-WEIGHT: bold">10 12 15 19</TD><TD style="FONT-WEIGHT: bold">13 14 18 20</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">63</TD><TD style="FONT-WEIGHT: bold">01 02 07 15</TD><TD style="FONT-WEIGHT: bold">03 04 08 10</TD><TD style="FONT-WEIGHT: bold">05 13 19 20</TD><TD style="FONT-WEIGHT: bold">06 09 14 17</TD><TD style="FONT-WEIGHT: bold">11 12 16 18</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">64</TD><TD style="FONT-WEIGHT: bold">01 02 09 17</TD><TD style="FONT-WEIGHT: bold">03 04 11 19</TD><TD style="FONT-WEIGHT: bold">05 07 13 15</TD><TD style="FONT-WEIGHT: bold">06 08 14 16</TD><TD style="FONT-WEIGHT: bold">10 12 18 20</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">65</TD><TD style="FONT-WEIGHT: bold">01 02 10 11</TD><TD style="FONT-WEIGHT: bold">03 04 05 07</TD><TD style="FONT-WEIGHT: bold">06 08 13 19</TD><TD style="FONT-WEIGHT: bold">09 12 14 15</TD><TD style="FONT-WEIGHT: bold">16 17 18 20</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">66</TD><TD style="FONT-WEIGHT: bold">....Up to 57 ROW</TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE>

Kind regards
Sezuh

 

[sezuh]

Hi,
Thanks Dasu for rewording my problem i think it make more sense now.
Mike, thank you very much for your code but unfortunately its only giving missing numbers from column "A" and also there are alot of repeat sequence .i need only the string in "B2:C58" to be re-arranged so each row have 1 to 20 number sequence ,like the example in post #1.
Anyway thanks ever so much for the effort,much obliged.
Sezuh

 

[sezuh]

Mike,
After i tried the code i realised this code is out of world if you could add one criteria not to duplicate and repeat sequence.It might not solve this problem but it would solve 90% of it.I would very greatful if you or someone else could modify the code .here is a small example after i changed two range ,i coulored duplicate;
Sheet1

<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: 114px"><COL style="WIDTH: 84px"><COL style="WIDTH: 74px"></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></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD style="COLOR: #008080">Result after Code</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD style="TEXT-ALIGN: right">01 02 </TD><TD style="TEXT-ALIGN: right">03 04 </TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">05 06 </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="TEXT-ALIGN: right">01 03 </TD><TD style="TEXT-ALIGN: right">02 04 </TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">05 06 </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="TEXT-ALIGN: right">01 04 </TD><TD style="TEXT-ALIGN: right">02 03 </TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">05 06 </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="TEXT-ALIGN: right">01 05</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="TEXT-ALIGN: right">01 06</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="COLOR: #0066cc">Expected result</TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="TEXT-ALIGN: right">01 02 </TD><TD style="TEXT-ALIGN: right">03 05</TD><TD style="TEXT-ALIGN: right">04 06 </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="TEXT-ALIGN: right">01 03 </TD><TD style="TEXT-ALIGN: right">02 06</TD><TD style="TEXT-ALIGN: right">04 05 </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="TEXT-ALIGN: right">01 04 </TD><TD style="TEXT-ALIGN: right">02 03</TD><TD style="TEXT-ALIGN: right">05 06 </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="TEXT-ALIGN: right">01 05</TD><TD style="TEXT-ALIGN: right">02 04</TD><TD style="TEXT-ALIGN: right">03 06</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="TEXT-ALIGN: right">01 06</TD><TD style="TEXT-ALIGN: right">02 05</TD><TD style="TEXT-ALIGN: right">03 04 </TD></TR></TBODY></TABLE>

Thanks again
Sezuh

 

[MickG]

Based on the assumption that the data produced (in column "B to E) from by My previous code where the right numbers but needed to be randomized.
Try this code after running the previous.
It should randomize each row, so hopefully they are all different.

[COLOR="Navy"]Sub[/COLOR] MG25Jun10
[COLOR="Navy"]Dim[/COLOR] Rng    [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] Dn     [COLOR="Navy"]As[/COLOR] Range
[COLOR="Navy"]Dim[/COLOR] txt    [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]String[/COLOR]
[COLOR="Navy"]Dim[/COLOR] c      [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Integer[/COLOR]
[COLOR="Navy"]Dim[/COLOR] R      [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Integer[/COLOR]
[COLOR="Navy"]Dim[/COLOR] n      [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Integer[/COLOR]
[COLOR="Navy"]Dim[/COLOR] AcFray [COLOR="Navy"]As[/COLOR] Variant
[COLOR="Navy"]Dim[/COLOR] Fray   [COLOR="Navy"]As[/COLOR] Variant
[COLOR="Navy"]Dim[/COLOR] Rw     [COLOR="Navy"]As[/COLOR] Variant
[COLOR="Navy"]Dim[/COLOR] t
[COLOR="Navy"]Set[/COLOR] Rng = Range("B2:B58")
[COLOR="Navy"]For[/COLOR] [COLOR="Navy"]Each[/COLOR] Dn [COLOR="Navy"]In[/COLOR] Rng
    [COLOR="Navy"]For[/COLOR] n = 1 To 4
        txt = txt & " " & Trim(Dn(, n))
    [COLOR="Navy"]Next[/COLOR] n
    [COLOR="Navy"]With[/COLOR] Application
        Fray = oRnd(.Transpose(.Transpose(Split(Mid(txt, 2), " "))))
    [COLOR="Navy"]End[/COLOR] With
    t = UBound(Fray)
    ReDim FinRay(1 To 4)
    txt = ""
    R = 0
[COLOR="Navy"]For[/COLOR] [COLOR="Navy"]Each[/COLOR] Rw [COLOR="Navy"]In[/COLOR] Fray
    c = c + 1
    txt = txt & " " & Rw
    [COLOR="Navy"]If[/COLOR] c Mod 4 = 0 [COLOR="Navy"]Then[/COLOR]
        R = R + 1
        FinRay(R) = Mid(txt, 2)
        txt = ""
    [COLOR="Navy"]End[/COLOR] If
[COLOR="Navy"]Next[/COLOR] Rw
Dn.Resize(, 4) = FinRay
[COLOR="Navy"]Next[/COLOR] Dn
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]
Function oRnd(ByRef Ray [COLOR="Navy"]As[/COLOR] Variant) [COLOR="Navy"]As[/COLOR] Variant
[COLOR="Navy"]Dim[/COLOR] num    [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Integer[/COLOR]
[COLOR="Navy"]Dim[/COLOR] n      [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Integer[/COLOR]
[COLOR="Navy"]Dim[/COLOR] txt    [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]String[/COLOR]
[COLOR="Navy"]Dim[/COLOR] Rw     [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Integer[/COLOR]
[COLOR="Navy"]Dim[/COLOR] TxRay() [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]String[/COLOR]
[COLOR="Navy"]Dim[/COLOR] c      [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Integer[/COLOR]
[COLOR="Navy"]Dim[/COLOR] p      [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Integer[/COLOR]
[COLOR="Navy"]Dim[/COLOR] rws    [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Integer[/COLOR]
[COLOR="Navy"]Dim[/COLOR] nRay [COLOR="Navy"]As[/COLOR] Variant
ReDim nRay(1 To UBound(Ray))
Randomize
rws = UBound(Ray)
[COLOR="Navy"]For[/COLOR] Rw = 1 To rws
    c = 0: p = p + 1
      num = Int(Rnd * UBound(Ray)) + 1
        nRay(p) = Ray(num)
[COLOR="Navy"]For[/COLOR] n = 1 To UBound(Ray)
    [COLOR="Navy"]If[/COLOR] Not Ray(n) = Ray(num) [COLOR="Navy"]Then[/COLOR]
        ReDim Preserve TxRay(c)
        TxRay(c) = n
        c = c + 1
    [COLOR="Navy"]End[/COLOR] If
[COLOR="Navy"]Next[/COLOR] n
Ray = Application.Transpose(Application.Index(Ray, Application.Transpose(Array(TxRay))))
[COLOR="Navy"]Next[/COLOR] Rw
oRnd = nRay
[COLOR="Navy"]End[/COLOR] Function
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]

Regards Mick

 

[sezuh]

Hi Mick,
thanks very much for the second code but there is no need for this because your code in post #10 is fantastic it only need modification to prevent duplicate and repeated numbers occuring otherwise its fine.here is an example;ei In "a2" there 3 and 5 and in "B2" repeated and so on...and i coloured duplicate sequence.
<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 11pt; FONT-FAMILY: Calibri,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><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></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD>LIST after macro</TD><TD></TD><TD></TD><TD></TD><TD></TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">01 02 03 05</TD><TD style="COLOR: #00ccff">03 04 05 06 </TD><TD style="COLOR: #ffcc00">07 08 09 10 </TD><TD>11 12 13 14 </TD><TD>15 16 17 18 </TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">01 02 04 20</TD><TD style="COLOR: #ff0000">17 18 19 20 </TD><TD>05 06 07 08 </TD><TD style="COLOR: #ff0000">09 10 11 12 </TD><TD>13 14 15 16 </TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">01 02 06 08</TD><TD style="COLOR: #008080">15 16 17 18 </TD><TD style="COLOR: #00ccff">03 04 05 06 </TD><TD style="COLOR: #ffcc00">07 08 09 10 </TD><TD>11 12 13 14 </TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">01 02 07 15</TD><TD>13 14 15 16 </TD><TD style="COLOR: #ff0000">17 18 19 20 </TD><TD>05 06 07 08 </TD><TD style="COLOR: #ff0000">09 10 11 12 </TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">01 02 09 17</TD><TD style="COLOR: #666699">11 12 13 14 </TD><TD style="COLOR: #008080">15 16 17 18 </TD><TD style="COLOR: #00ccff">03 04 05 06 </TD><TD style="COLOR: #ffcc00">07 08 09 10 </TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">01 02 10 11</TD><TD style="COLOR: #ff0000">09 10 11 12 </TD><TD>13 14 15 16 </TD><TD style="COLOR: #ff0000">17 18 19 20 </TD><TD>05 06 07 08 </TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">01 02 12 13</TD><TD style="COLOR: #ffcc00">07 08 09 10 </TD><TD style="COLOR: #666699">11 12 13 14 </TD><TD style="COLOR: #008080">15 16 17 18 </TD><TD style="COLOR: #00ccff">03 04 05 06 </TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">01 02 14 18</TD><TD>05 06 07 08 </TD><TD>09 10 11 12 </TD><TD>13 14 15 16 </TD><TD style="COLOR: #ff0000">17 18 19 20 </TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">01 02 16 19</TD><TD style="COLOR: #00ccff">03 04 05 06 </TD><TD style="COLOR: #ffcc00">07 08 09 10 </TD><TD style="COLOR: #666699">11 12 13 14 </TD><TD style="COLOR: #008080">15 16 17 18 </TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">01 03 13 15</TD><TD style="COLOR: #ff0000">17 18 19 20 </TD><TD>05 06 07 08 </TD><TD style="COLOR: #ff0000">09 10 11 12 </TD><TD>13 14 15 16 </TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">01 03 16 17</TD><TD>15 16 17 18 </TD><TD>02 04 05 06 </TD><TD style="COLOR: #ffcc00">07 08 09 10 </TD><TD style="COLOR: #666699">11 12 13 14 </TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">01 03 19 20</TD><TD>13 14 15 16 </TD><TD style="COLOR: #ff0000">17 18 19 20 </TD><TD>05 06 07 08 </TD><TD style="COLOR: #ff0000">09 10 11 12 </TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">01 03 04 18</TD><TD>11 12 13 14 </TD><TD>15 16 17 18 </TD><TD>02 04 05 06 </TD><TD style="COLOR: #ffcc00">07 08 09 10 </TD></TR></TBODY></TABLE>


I'm very sorry for all this hassle ,but i really appreciate your help.
Thanks
Sezuh

 

[sezuh]

Hi,
I noticed the code in post #10 only assigning consecutive,and repeated numbers only,
if

nRay = Array("01", "02", "03", "04", "05",....................... "20")

and each cell got 4 numbers ,wouldnt be better if the code assign from; combin(20,4)=4845, in that way there will be no duplicate??.
Also would it help to put A2:e58 in one column and have excel formula or vb code to give result similar to the list in post #1.
Thanks and kind regards
sezuh

 

[mirabeau]

Sezuh,

In your post #1, were you wanting the results in cols B to E to be taken (with suitable reordering etc.) from the cells in your 57 original rows in Cols B to E?

Or would any results, provided they otherwise satisfy the properties you indicate (that is, no duplication and individual numbers in the groups from 1 to 20), do, even if they didn't all come from the original B1:E57 data (or B2:E58 if you use a header)?

 

[sezuh]

Mirabeau,
Thank you very much for you response , preferably yes i would like my results in cols B to E to be taken (with suitable reordering etc.) from the cells in my 57 original rows in Cols B to E.
But if that not possible then i will except any result,provided they satisfy the criteria that is, no duplication and individual numbers in the groups from 1 to 20, even if they didn't all come from the original B2:E58 data,and any three number(in 4 Numbers string ) can be used more than once,ei;

11 12 13 14 ,11 12 17 20,12 14 16 20,12 13 15 19...

they can be assign as a pair like above example with different numbers but no more than 9 times.
thanks again
Sezuh

 

[sezuh]

hi,
After experimenting for hours with code in post #10 i changed this line ;

nRay = Array("01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12", "13", "14", "15", "16", "17", "18", "19", "20")

to this(B2:E58);

nRay = Array("02 03 08 16", "05 10 15 20", "09 11 14 18", " 12 13 17 19", "02  03 10 18", "05  06 16 17", "07  09 14 20", "11 12 13 15")

and from this

If c = 4 Then

to this

If c = 1 Then

after first row result it gives "error 9" and highlite this row when i debug the code;

If nRay(n) = Dels(Fd) Then

the question is instead of writing "B2:E58" list in the code is there a way
put all of them in one column then "nRay = Array ???? apply it to the code?
here the result of experment,but still there are duplicate;
<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 11pt; FONT-FAMILY: Calibri,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><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></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD>01 04 06 07</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">02 03 10 18 </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">05 06 16 17 </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">07 09 14 20 </TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">11 12 13 15 </TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD>01 04 08 19</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD>01 04 09 12</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD>01 04 10 14</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD>01 04 11 15</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></TD></TR></TBODY></TABLE>

Regards
Sezuh

 

[MickG]

I don't know how you achieved those duplicats because:-
If you run My first code it fills in each column from "B to E" with 16 number that along with the 4 numbers in column "A" make the sequence of numbers "1 to 20", which may and obviouly are duplicated in other rows.
Now if you run the 2nd code, All the numbers in columns "B to E" are randomised, as shown below. I thought this was what you wanted !!!!
The code below checks for duplicates of any cells in columns "B to E" , so far it has not shown any.
Please use it for testing.

[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]
1.                                                                       
2.      01 02 03 05   19 13 14 18  15 08 11 12  07 20 09 04  17 10 06 16 
3.      01 02 04 20   09 16 03 19  14 17 13 05  12 18 06 10  07 11 15 08 
4.      01 02 06 08   14 07 03 04  15 16 10 17  19 13 20 18  12 11 05 09 
5.      01 02 07 15   04 12 13 06  16 03 10 05  09 18 17 08  11 20 19 14 
6.      01 02 09 17   07 08 18 20  04 16 03 14  05 13 10 11  15 12 06 19 
7.      01 02 10 11   13 15 06 07  08 17 18 09  05 14 19 03  12 16 20 04 
8.      01 02 12 13   17 10 11 04  18 09 08 05  06 15 14 07  19 16 03 20 
9.      01 02 14 18   06 15 03 07  19 04 12 11  13 10 05 16  20 09 17 08 
10.     01 02 16 19   09 11 07 03  10 17 06 05  12 14 15 18  04 08 20 13 
11.     01 03 13 15   14 20 07 02  05 11 16 18  10 06 12 08  04 09 19 17 
12.     01 03 16 17   05 06 15 07  08 02 19 09  20 10 11 13  12 04 14 18 
13.     01 03 19 20   08 02 04 18  14 16 10 15  12 06 17 11  09 13 07 05 
14.     01 03 04 18   16 07 12 05  17 10 14 08  02 09 15 20  19 06 11 13 
15.     01 03 06 10   17 07 16 05  08 04 18 15  13 14 02 19  20 12 11 09 
16.     01 03 07 12   08 11 06 10  05 17 19 02  20 15 16 18  04 14 09 13 
17.     01 03 08 14   11 06 13 04  17 12 15 18  19 10 05 02  09 16 20 07 
18.     01 03 09 11   16 15 12 05  13 06 02 10  20 14 07 17  08 18 04 19 
19.     01 04 10 14   05 19 20 07  13 16 03 15  08 09 18 17  11 06 12 02 
20.     01 04 11 15   08 17 06 03  05 14 19 12  07 13 10 02  20 16 09 18 
21.     01 04 13 16   18 20 14 05  06 03 19 15  10 08 02 09  07 12 17 11 
22.     01 04 05 17   02 18 03 06  15 20 13 11  09 12 16 10  14 07 08 19 
23.     01 04 06 07   09 05 13 11  19 16 10 08  17 03 12 14  15 02 20 18 
24.     01 04 08 19   11 20 15 05  09 12 02 18  10 06 17 13  14 03 16 07 
25.     01 04 09 12   20 06 07 08  13 02 05 14  18 10 16 19  17 03 11 15 
26.     01 05 10 19   04 02 13 06  20 17 16 03  14 08 07 09  12 18 15 11 
27.     01 05 11 14   08 18 17 19  09 13 10 15  06 03 16 04  12 07 20 02 
28.     01 05 12 15   19 14 20 06  16 03 09 02  07 18 13 11  08 17 04 10 
29.     01 05 16 18   03 11 08 02  09 20 06 15  04 19 12 17  13 10 07 14 
30.     01 05 06 13   12 17 16 04  09 10 07 02  14 20 03 11  19 18 15 08 
31.     01 05 07 20   12 15 02 06  19 11 13 03  08 17 14 18  16 09 04 10 
32.     01 05 08 09   02 19 12 10  03 04 16 14  15 18 07 06  11 17 20 13 
33.     01 06 11 16   05 17 15 03  12 19 08 04  09 18 14 10  07 02 20 13 
34.     01 06 12 19   09 13 03 18  02 15 04 17  07 16 10 14  20 05 08 11 
35.     01 06 14 20   17 16 10 02  04 07 05 09  13 18 03 19  08 11 15 12 
36.     01 06 15 17   03 07 12 04  20 18 13 16  11 09 19 05  14 02 10 08 
37.     01 06 09 18   13 11 02 05  20 10 16 07  03 14 15 17  04 08 12 19 
38.     01 07 10 17   16 06 08 20  11 04 12 19  18 09 03 15  13 14 02 05 
39.     01 07 11 18   05 12 16 03  13 17 10 08  06 14 20 02  19 15 09 04 
40.     01 07 14 16   05 11 02 04  08 19 18 09  03 12 13 17  15 20 06 10 
41.     01 07 08 13   16 15 10 05  04 11 20 17  09 06 02 03  19 18 14 12 
42.     01 07 09 19   18 11 16 02  14 04 13 08  05 10 15 06  12 17 03 20 
43.     01 08 10 15   03 09 04 19  06 20 11 02  05 13 12 16  17 07 14 18 
44.     01 08 11 17   13 12 10 20  05 09 07 14  06 04 19 16  18 03 15 02 
45.     01 08 12 18   17 02 11 03  05 07 20 04  14 06 19 10  15 13 16 09 
46.     01 08 16 20   06 05 02 04  09 17 03 13  19 07 14 12  18 11 10 15 
47.     01 09 10 20   11 03 07 19  15 13 16 04  17 02 05 14  08 06 18 12 
48.     01 09 13 14   20 06 17 02  16 04 18 11  05 03 15 19  10 07 12 08 
49.     01 09 15 16   20 05 02 06  04 18 19 17  12 10 07 13  08 14 11 03 
50.     01 10 12 16   04 03 08 20  14 15 13 11  07 09 19 18  17 06 02 05 
51.     01 10 13 18   12 06 16 03  15 05 19 02  20 09 11 04  07 17 14 08 
52.     01 11 12 20   16 03 04 18  06 02 10 15  14 09 05 08  13 17 19 07 
53.     01 11 13 19   06 08 12 02  07 15 16 04  03 14 18 17  10 09 05 20 
54.     01 12 14 17   10 18 09 02  03 07 04 16  06 08 19 05  15 13 11 20 
55.     01 13 17 20   19 02 03 06  05 15 08 07  14 09 11 10  18 12 16 04 
56.     01 14 15 19   04 17 07 20  11 10 16 13  06 03 02 09  05 12 08 18 
57.     01 15 18 20   12 03 14 04  13 05 02 08  17 07 16 19  09 10 06 11 
58.     01 17 18 19   15 16 03 14  05 20 11 13  09 04 06 02  12 07 10 08

[COLOR="Navy"]Sub[/COLOR] MG27Jun20
[COLOR="Navy"]Dim[/COLOR] Rng [COLOR="Navy"]As[/COLOR] Range, Dn [COLOR="Navy"]As[/COLOR] Range, n [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long[/COLOR]
[COLOR="Navy"]Dim[/COLOR] c [COLOR="Navy"]As[/COLOR] [COLOR="Navy"]Long,[/COLOR] txt
[COLOR="Navy"]Set[/COLOR] Rng = Range("B2:B58")
[COLOR="Navy"]With[/COLOR] CreateObject("scripting.dictionary")
.CompareMode = vbTextCompare
[COLOR="Navy"]For[/COLOR] n = 0 To 3
    [COLOR="Navy"]For[/COLOR] [COLOR="Navy"]Each[/COLOR] Dn [COLOR="Navy"]In[/COLOR] Rng.Offset(, n)
        [COLOR="Navy"]If[/COLOR] Not .Exists(Dn.value) [COLOR="Navy"]Then[/COLOR]
            .Add Dn.value, Dn
        [COLOR="Navy"]Else[/COLOR]
            txt = txt & .Item(Dn.value).Address & "/" & Dn.Address & chr(10)
            c = c + 1
        [COLOR="Navy"]End[/COLOR] If
    [COLOR="Navy"]Next[/COLOR] Dn
[COLOR="Navy"]Next[/COLOR] n
[COLOR="Navy"]End[/COLOR] With
[COLOR="Navy"]If[/COLOR] c = 0 [COLOR="Navy"]Then[/COLOR]
MsgBox "No Dups found"
[COLOR="Navy"]Else[/COLOR]
MsgBox "There where " & c & "Dups"
MsgBox txt
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]If[/COLOR]
[COLOR="Navy"]End[/COLOR] [COLOR="Navy"]Sub[/COLOR]

Regards Mick

 

[sezuh]

Mick, thanks ever so much for your wonderful help, realy appreciated.
but my data is not random its ,"combin(20,3)/combin(4,3)=285 ,each 3 numbers out 20 will appear only once,every two numbers will appear 9 times, kind of balanced combination.Unless someone come up with better solution than this ..i've to accept your solution.
May i ask what change do i have to make to this line if i have two column known data "A" and "B" and column C to E to be filled by code?

Set Rng = Range(Range("A2"), Range("A" & rows.Count).End(xlUp))

I'm realy sorry for all the confusion.
Kind regards
Sezuh