generate a list base on differences.

[ctrlrowdim]

Hello, I am newbie trying to find how to generate a list base on the differences of another list. let me explain; I have a list of combination A1:F2200 each row of course the numbers have difference, example:
<TABLE style="WIDTH: 288pt; BORDER-COLLAPSE: collapse; mso-padding-bottom-alt: 0in; mso-padding-left-alt: 5.4pt; mso-padding-right-alt: 5.4pt; mso-padding-top-alt: 0in" border=0 cellSpacing=0 cellPadding=0 width=384 x:str><COLGROUP><COL style="WIDTH: 48pt" span=6 width=64><TBODY><TR style="HEIGHT: 14.25pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0" height=19><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 14.25pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 height=19 width=64 x:num>5</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 width=64 x:num>8</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 width=64 x:num>9</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 width=64 x:num>16</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 width=64 x:num>20</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 width=64 x:num>45</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 1" height=19><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 height=19 x:num>6</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 x:num>20</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 x:num>27</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 x:num>33</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 x:num>42</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 x:num>45</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 2" height=19><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 height=19 x:num>1</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 x:num>2</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 x:num>6</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 x:num>14</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 x:num>19</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 x:num>31</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 3" height=19><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 height=19 x:num>6</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 x:num>12</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 x:num>17</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 x:num>21</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 x:num>26</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 x:num>42</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 4; mso-yfti-lastrow: yes" height=19><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 height=19 x:num>7</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 x:num>18</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 x:num>37</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 x:num>41</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 x:num>45</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl22 x:num>51</TD></TR></TBODY></TABLE>
as you see the difference in the first row for this small example is <TABLE style="WIDTH: 240pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=320 x:str><COLGROUP><COL style="WIDTH: 48pt" span=5 width=64><TBODY><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: windowtext 1pt dashed; BORDER-LEFT: windowtext 1pt dashed; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 14.25pt; BORDER-TOP: windowtext 1pt dashed; BORDER-RIGHT: windowtext 1pt dashed; PADDING-TOP: 0in" class=xl24 height=19 width=64 align=right x:num>3</TD><TD style="BORDER-BOTTOM: windowtext 1pt dashed; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 1pt dashed; BORDER-RIGHT: windowtext 1pt dashed" class=xl24 width=64 align=right x:num>1</TD><TD style="BORDER-BOTTOM: windowtext 1pt dashed; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 1pt dashed; BORDER-RIGHT: windowtext 1pt dashed" class=xl24 width=64 align=right x:num>7</TD><TD style="BORDER-BOTTOM: windowtext 1pt dashed; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 1pt dashed; BORDER-RIGHT: windowtext 1pt dashed" class=xl24 width=64 align=right x:num>4</TD><TD style="BORDER-BOTTOM: windowtext 1pt dashed; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 1pt dashed; BORDER-RIGHT: windowtext 1pt dashed" class=xl24 width=64 align=right x:num>25</TD></TR></TBODY></TABLE> and the list base on this difference is :
<TABLE style="WIDTH: 288pt; BORDER-COLLAPSE: collapse; mso-padding-bottom-alt: 0in; mso-padding-left-alt: 5.4pt; mso-padding-right-alt: 5.4pt; mso-padding-top-alt: 0in" border=0 cellSpacing=0 cellPadding=0 width=384 x:str><COLGROUP><COL style="WIDTH: 48pt" span=6 width=64><TBODY><TR style="HEIGHT: 14.25pt; mso-yfti-firstrow: yes; mso-yfti-irow: 0" height=19><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 14.25pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 height=19 width=64 x:num>1</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 width=64 x:num>4</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 width=64 x:num>5</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 width=64 x:num>12</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 width=64 x:num>16</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; WIDTH: 48pt; BORDER-TOP: windowtext 1.5pt solid; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 width=64 x:num>41</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 1" height=19><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 height=19 x:num>2</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>5</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>6</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>13</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>17</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>42</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 2" height=19><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 height=19 x:num>3</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>6</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>7</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>14</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>18</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>43</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 3" height=19><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 height=19 x:num>4</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>7</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>8</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>15</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>19</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>44</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 4" height=19><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 height=19 x:num>5</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>8</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>9</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>16</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>20</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>45</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 5" height=19><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 height=19 x:num>6</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>9</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>10</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>17</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>21</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>46</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 6" height=19><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 height=19 x:num>7</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>10</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>11</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>18</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>22</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>47</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 7" height=19><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 height=19 x:num>8</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>11</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>12</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>19</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>23</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>48</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 8" height=19><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 height=19 x:num>9</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>12</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>13</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>20</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>24</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>49</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 9" height=19><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 height=19 x:num>10</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>13</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>14</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>21</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>25</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>50</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 10" height=19><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 height=19 x:num>11</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>14</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>15</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>22</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>26</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>51</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 11" height=19><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 height=19 x:num>12</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>15</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>16</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>23</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>27</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>52</TD></TR><TR style="HEIGHT: 14.25pt; mso-yfti-irow: 12; mso-yfti-lastrow: yes" height=19><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext 1.5pt solid; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; HEIGHT: 14.25pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 height=19 x:num>13</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>16</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>17</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>24</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>28</TD><TD style="BORDER-BOTTOM: windowtext 1.5pt solid; BORDER-LEFT: windowtext; PADDING-BOTTOM: 0in; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1.5pt solid; PADDING-TOP: 0in" class=xl24 x:num>53</TD></TR></TBODY></TABLE>
the maximum number is 53. doing this one time find, but I have to do it with my 2200 difference, any question, advice or comment positive or negative welcome.

 

[cyrilbrd]

ctrlrowdim,
read the various posts. Especially post#7 of mikerickson.
"If the goal is to put a row number in H1 and get the List 2 from the indicated row:

You could put the array formula =OFFSET($A$1:$F$1, H1-1,0) in K1:P1 and then put the formula =K$1+(ROWS($1:1)-$K$1) in a cell and drag down an right.

If the OP's goal is to find out how many rows of the second table are needed until 53 is reached
(13 for the row 5, 8, 9, 16, 20, 45),
that can be calculated with the formula =53-(F1-A1)"

Is this what you needed for the first part? "to find out how many rows of the second table are needed until 53 is reached"

Awaiting to read from you.

As How to Find Duplicates in your list, you could use conditional formatting with a formula such as

=COUNTIF(A:A,A2)>1

.

Or a Helper Column with a formula such as

=IF(COUNTIF(H:H,H1)>1,"Duplicate","")

 

[ctrlrowdim]

Thanks, CyrilBrd. I read the all post, I really apreciate, the idea here is to write a vba routine that I can insert in the big code I already have, I am working in a long code to generate conditional combinations, one of the definitions are the one you know in this post but I have more filter ideas, but I think to post all of them in one time nobody will help. so is not formulas, I really need a complex code, feel free to send me a private message. until now I never see a book specialize in combinatoric code in excel, if you know one let me know. thank you, thank you.

 

[cyrilbrd]

Oh, why don't you use Mathematica then?
You could do subsets and permutations, partitions and compositions, graph construction, algorithm (dijkstra, isomorphism and so on).
But surely Excel will be up to the task.

Cheers!.