EXCEL help please...?

[sezuh]

Hi,
Thanks for the excellent advise and help you gave me in my previous treads,very much appreciated.
I’m hoping you would spare me some of your time for this one.
I have a list of 2470 rows (col. A ) made of 1 to 40 numbers each cell consist of 4 numbers ,and i have another list in col.”C” made of 1 to247 consecutive numbers,i would like assign those numbers to each row in col.”B”with equal proportion,in such a way each number(1 to 247) to be assign to(1 to 40) in column “A” only once.I hope somehow i’m making some sense....
Here as an example, the only reason i input list in 3 column is to save same space but the logic is the same,i assign 28 numbers to 84 rows equally.
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: 64px"><COL style="WIDTH: 33px"><COL style="WIDTH: 64px"><COL style="WIDTH: 45px"><COL style="WIDTH: 64px"><COL style="WIDTH: 39px"><COL style="WIDTH: 134px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD>list</TD><TD> </TD><TD>list cont.</TD><TD> </TD><TD>list cont.</TD><TD> </TD><TD>Nmbers to be assign</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 03</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">02 03 04</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">24</TD><TD style="TEXT-ALIGN: right">03 05 08</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">27</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">1</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 02 04</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">02 03 05</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">16</TD><TD style="TEXT-ALIGN: right">03 05 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">4</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">2</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 02 05</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">02 03 06</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">14</TD><TD style="TEXT-ALIGN: right">03 06 07</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">18</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">3</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 02 06</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">4</TD><TD style="TEXT-ALIGN: right">02 03 07</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">15</TD><TD style="TEXT-ALIGN: right">03 06 08</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">5</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">4</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 02 07</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">5</TD><TD style="TEXT-ALIGN: right">02 03 08</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">20</TD><TD style="TEXT-ALIGN: right">03 06 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">6</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">5</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="TEXT-ALIGN: right">01 02 08</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">6</TD><TD style="TEXT-ALIGN: right">02 03 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">21</TD><TD style="TEXT-ALIGN: right">03 07 08</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">7</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">6</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 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">7</TD><TD style="TEXT-ALIGN: right">02 04 05</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">13</TD><TD style="TEXT-ALIGN: right">03 07 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">3</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">7</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 04</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">8</TD><TD style="TEXT-ALIGN: right">02 04 06</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">27</TD><TD style="TEXT-ALIGN: right">03 08 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">2</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">8</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 03 05</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">9</TD><TD style="TEXT-ALIGN: right">02 04 07</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">28</TD><TD style="TEXT-ALIGN: right">04 05 06</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">7</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">9</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 03 06</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">02 04 08</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">11</TD><TD style="TEXT-ALIGN: right">04 05 07</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">6</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">10</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 03 07</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">11</TD><TD style="TEXT-ALIGN: right">02 04 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">10</TD><TD style="TEXT-ALIGN: right">04 05 08</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">1</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">11</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="TEXT-ALIGN: right">01 03 08</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">12</TD><TD style="TEXT-ALIGN: right">02 05 06</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">12</TD><TD style="TEXT-ALIGN: right">04 05 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">5</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">12</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="TEXT-ALIGN: right">01 03 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">13</TD><TD style="TEXT-ALIGN: right">02 05 07</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">25</TD><TD style="TEXT-ALIGN: right">04 06 07</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">21</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">13</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="TEXT-ALIGN: right">01 04 05</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">14</TD><TD style="TEXT-ALIGN: right">02 05 08</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">18</TD><TD style="TEXT-ALIGN: right">04 06 08</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">3</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">14</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD style="TEXT-ALIGN: right">01 04 06</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">15</TD><TD style="TEXT-ALIGN: right">02 05 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">26</TD><TD style="TEXT-ALIGN: right">04 06 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">20</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">15</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD style="TEXT-ALIGN: right">01 04 07</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">16</TD><TD style="TEXT-ALIGN: right">02 06 07</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">9</TD><TD style="TEXT-ALIGN: right">04 07 08</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">4</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">16</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">18</TD><TD style="TEXT-ALIGN: right">01 04 08</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">17</TD><TD style="TEXT-ALIGN: right">02 06 08</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">22</TD><TD style="TEXT-ALIGN: right">04 07 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">12</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">17</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">19</TD><TD style="TEXT-ALIGN: right">01 04 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">18</TD><TD style="TEXT-ALIGN: right">02 06 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">17</TD><TD style="TEXT-ALIGN: right">04 08 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">9</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">18</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">20</TD><TD style="TEXT-ALIGN: right">01 05 06</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">19</TD><TD style="TEXT-ALIGN: right">02 07 08</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">19</TD><TD style="TEXT-ALIGN: right">05 06 07</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">2</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">19</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">21</TD><TD style="TEXT-ALIGN: right">01 05 07</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">20</TD><TD style="TEXT-ALIGN: right">02 07 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">8</TD><TD style="TEXT-ALIGN: right">05 06 08</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">8</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">20</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">22</TD><TD style="TEXT-ALIGN: right">01 05 08</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">21</TD><TD style="TEXT-ALIGN: right">02 08 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">23</TD><TD style="TEXT-ALIGN: right">05 06 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">11</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">21</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">23</TD><TD style="TEXT-ALIGN: right">01 05 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">22</TD><TD style="TEXT-ALIGN: right">03 04 05</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">23</TD><TD style="TEXT-ALIGN: right">05 07 08</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">10</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">22</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">24</TD><TD style="TEXT-ALIGN: right">01 06 07</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">23</TD><TD style="TEXT-ALIGN: right">03 04 06</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">26</TD><TD style="TEXT-ALIGN: right">05 07 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">24</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">23</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">25</TD><TD style="TEXT-ALIGN: right">01 06 08</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">24</TD><TD style="TEXT-ALIGN: right">03 04 07</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">22</TD><TD style="TEXT-ALIGN: right">05 08 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">15</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">24</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">26</TD><TD style="TEXT-ALIGN: right">01 06 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">25</TD><TD style="TEXT-ALIGN: right">03 04 08</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">25</TD><TD style="TEXT-ALIGN: right">06 07 08</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">13</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">25</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">27</TD><TD style="TEXT-ALIGN: right">01 07 08</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">26</TD><TD style="TEXT-ALIGN: right">03 04 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">19</TD><TD style="TEXT-ALIGN: right">06 07 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">1</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">26</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">28</TD><TD style="TEXT-ALIGN: right">01 07 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">27</TD><TD style="TEXT-ALIGN: right">03 05 06</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">28</TD><TD style="TEXT-ALIGN: right">06 08 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">16</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">27</TD></TR><TR style="HEIGHT: 18px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">29</TD><TD style="TEXT-ALIGN: right">01 08 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">28</TD><TD style="TEXT-ALIGN: right">03 05 07</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">17</TD><TD style="TEXT-ALIGN: right">07 08 09</TD><TD style="COLOR: #ff0000; TEXT-ALIGN: right">14</TD><TD style="COLOR: #008080; TEXT-ALIGN: right">28</TD></TR></TBODY></TABLE>

Thanks in advance for your help and suggestions.
Sezuh

 

[sezuh]

Any clue to start with........?
Thanks

 

[sezuh]

Any suggestion please...?
Thanks
Sezuh

 

[sezuh]

I'm very sorry for bumping................
Thanks.

 

[sezuh]

Please let me know if you need more information....
Thanks

 

[sezuh]

This is how the list set up;
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: 120px"><COL style="WIDTH: 105px"><COL style="WIDTH: 195px"></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: 24px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">List</TD><TD> </TD><TD>Numbers to be assign to "B"</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD style="FONT-SIZE: 12pt; FONT-FAMILY: Times New Roman">01 02 03 04</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">1</TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-SIZE: 12pt; FONT-FAMILY: Times New Roman">01 02 05 08</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS; TEXT-ALIGN: right">2</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS; TEXT-ALIGN: right">2</TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="FONT-SIZE: 12pt; FONT-FAMILY: Times New Roman">01 02 06 10</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">3</TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-SIZE: 12pt; FONT-FAMILY: Times New Roman">01 02 07 09</TD><TD style="TEXT-ALIGN: right">4</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS; TEXT-ALIGN: right">4</TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-SIZE: 12pt; FONT-FAMILY: Times New Roman">01 02 11 12</TD><TD style="TEXT-ALIGN: right">5</TD><TD style="TEXT-ALIGN: right">5</TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD style="FONT-SIZE: 12pt; FONT-FAMILY: Times New Roman">01 02 13 19</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS; TEXT-ALIGN: right">6</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS; TEXT-ALIGN: right">6</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">8</TD><TD style="FONT-SIZE: 12pt; FONT-FAMILY: Times New Roman">01 02 14 18</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">7</TD><TD style="TEXT-ALIGN: right">7</TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">9</TD><TD style="FONT-SIZE: 12pt; FONT-FAMILY: Times New Roman">01 02 15 17</TD><TD style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; TEXT-ALIGN: right">8</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS; TEXT-ALIGN: right">8</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">10</TD><TD style="FONT-SIZE: 12pt; FONT-FAMILY: Times New Roman">01 02 16 20</TD><TD style="TEXT-ALIGN: right">9</TD><TD style="TEXT-ALIGN: right">9</TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">11</TD><TD style="FONT-SIZE: 12pt; FONT-FAMILY: Times New Roman">01 02 21 22</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS; TEXT-ALIGN: right">10</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS; TEXT-ALIGN: right">10</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">12</TD><TD style="FONT-SIZE: 12pt; FONT-FAMILY: Times New Roman">01 02 23 39</TD><TD>^</TD><TD>^</TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">13</TD><TD style="FONT-SIZE: 12pt; FONT-FAMILY: Times New Roman">^</TD><TD>^</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">^</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">14</TD><TD style="FONT-SIZE: 12pt; FONT-FAMILY: Times New Roman">^</TD><TD>^</TD><TD>^</TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="FONT-SIZE: 12pt; FONT-FAMILY: Times New Roman">^</TD><TD>^</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">^</TD></TR><TR style="HEIGHT: 19px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">16</TD><TD style="FONT-SIZE: 12pt; FONT-FAMILY: Times New Roman">^</TD><TD>^</TD><TD>^</TD></TR><TR style="HEIGHT: 20px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17</TD><TD style="FONT-SIZE: 12pt; FONT-FAMILY: Times New Roman">Up to 2470</TD><TD>Up to 2470</TD><TD style="FONT-SIZE: 10pt; FONT-FAMILY: Arial Unicode MS">Up to 247</TD></TR></TBODY></TABLE>

I need your wonderful help,Please.
thanks

 

[sezuh]

Re: EXCEL Formula help, please...?

Help please.....?

 

[sezuh]

Bump..............?

 

[mirabeau]

Sezuh,

Is there some relationship between the data you post in post#1 and in post#6?
Any relationship isn't obvious to me.

Why (in post#1) do you say "(col. A ) made of 1 to 40 numbers each cell consist of 4 numbers" and then give your example where cells in ColA only have 3 numbers?

Can I suggest that you try explaining more clearly, and be consistent about it, about just what it is you are looking for. Then more answers to assist you might be forthcoming.

A simple posted example of (say) 10 rows, clearly laid out and with fewer numbers, would help me at least to find out what your problem actually is.

Also I recall solving one of your problems previously, but my solution used the data as you posted it. But this was, apparently, not the data you wanted to use and the solution therefore seemingly didn't work on your non-posted data, so time spent on trying to solve your problems may not (again, for me at least) be time well spent.

Maybe these comments may be of some assistance to you.

 

[xenou]

sezuh,
I have no idea. But I can't help but be curious about your interest in combinatorial theories. Is this a hobby? Program of study in maths? Other... ? I've never known anyone take on so many difficult problems with such dedication (probably because for my part I run away from maths ... ).

Cheers,
ξ