Need formula help for a chart

[serge]

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
2
3
4			6	34	11	3	8	36	19	10	5	2	25	37	48	3
5
6		1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
7		2	2	2	2	2	2	2	2	2	2	2	2	2	2	2
8		3	3	3	3	3	3	3	3	3	3	4	3	3	3	3
9		4	4	4	4	5	4	4	4	4	4	5	5	4	4	5
10		5	5	5	5	6	6	5	5	5	5	6	6	6	5	6
11		6	6	6	6	7	7	7	6	6	7	8	7	7	7	8
12		7	8	7	7	8	8	8	8	7	8	9	9	8	8	9
13		9	10	9	8	9	10	9	9	9	10	11	10	10	9	10
14		13	14	11	10	11	12	11	10	10	11	12	12	11	11	12
15		15	16	15	16	17	18	13	12	13	14	15	13	13	12	13
16		24	25	17	18	19	20	19	14	15	16	17	16	14	14	15
17		25	26	26	27	28	29	21	22	23	24	25	18	17	15	16
18		26	27	27	28	29	30	30	31	32	33	34	35	19	18	19
19		31	32	28	29	30	31	31	32	33	34	35	36	36	20	21
20		33	34	33	34	35	36	32	33	34	35	36	37	37	37	38
21		36	37	38	39	40	41	42	43	44	45	46	47	48	38	39
22
Sheet

This table work column per column.
Each column is for a new day.

In Row 4 are the numbers that need to be found in the previous column.

example :
Number 6 in C4 is in cell B11 in the previous column. Then when I highlight B6:B21 and drag it over C6:C21 this number (6) BECOME THE NUMBER 1 in C6 and push down all the other numbers by 1 cell, and at the same time every number are added 1 when they pass over the next column (C).

So 1 become 2, 2 become 3 become 4, etc… since number 6 has been selected ( in C4 ), there would be no number 7 in column C ( since all numbers are suppose to added 1 in the next column over ), because now it become the number 1 in C6.

It look a little bit confusing but, it's very important to me.

To conclude, every single numbers need to be added 1 when they pass over the next column, and the number selected in row 4 become the number 1 in row 6.

Thank you for any help.

 

[Kentman]

Isn't this simply: if a number is selected in column 1 then the number after the corresponding number in column 2 should be the number +2 but all columns should start at one and increment down by one until the above condition is met?

Is that what you're trying to do?

 

[Gerald Higgins]

What it seems to be to me (which might be the same as what Kentman is saying, just expressed in another way) is .....

1) Start each column with a 1.
2) From row 7 downwards, each number is the number up 1 cell and to the left 1 cell, plus 1
2) When a number is specified in row 4, find that number in the column below, and add another 1 to every number after that.

Is that it ?

In which case, try this formula in C6, and copy across and down.
It generates the required results for columns C and D

=IF(ROW()=6,1,+B5+1)+(C$4<=C5)

I suspect there may be some "special cases" where this formula does not work.
For example, what happens when 1 is the value in row 4?
What happens if the value in row 4 is not found in the column below ?

 

[serge]

Hi gerald,

Thank you so much for getting back to that post and be persistent.

You are my savior one that one, your formula work exactly the way I needed it for all my tables.

I really do appreciate your help a 1000 times, Thank you.

Regards.
Serge.

 

[serge]

I encounter a small problem in the way the number come out after a number is been repeated in row 4, can this be solve ? other than that it's perfect.

I highlight the cell that are not the right return.
Sorry about the bad table - look at the next post please.

Thank you for looking at it.
Serge.

 

[serge]

Excel Workbook
	A	B	C	D	E	F	G	H
1
2
3
4			7	13	13	13	8
5
6		1	1	1	1	1	1
7		2	2	2	2	2	2
8		3	3	3	3	3	3
9		4	4	4	4	4	4
10		5	5	5	5	5	5
11		6	6	6	6	6	6
12		7	7	7	7	7	7
13		8	9	8	8	8	8
14		9	10	10	9	9	10
15		10	11	11	11	10	11
16		11	12	12	12	12	12
17		12	13	13	13	13	14
18		13	14	15	15	15	15
19		14	15	16	17	17	17
20		15	16	17	18	19	19
21		16	17	18	19	20	21
22
Sheet1

I encounter a small problem in the way the number come out after a number is been repeated in row 4, can this be solve ? other than that it's perfect.

I highlighted in red the cells that are not the right return.

E18 should be : 16

F18 should be : 17
F19 should be : 18

G16 should be : 13
G18 should be : 18
G19 should be : 19
G20 should be : 20


Thank you.

 

[serge]

Hi Gerald,

I'm posting a new explanation ( that is better I believe ) the formula you provided work fine, but when a number get repeated in row 4, the return is not right toward to bottom !!!

Here is the new details.

Each digit here represent the pool depth of a number from a different table.

So when a number is selected in that different table let say for example # 15.
This number 15 have a pool depth of 7 ( meaning 15 skip 7 draws before it got selected ).

So when I go over the next column to get ready for the new draw ( meaning adding 1 draw ) all my previous numbers will be added 1, but the number 15 which was at 7 WILL NOT go to 8, it just stop here for that number, and start back at 1, because it just have been selected, 7 will be removed from that new column and become number 1 on top of that new column and push all the other numbers down by 1 cell.

That's it I think, with this new explanation the process of the table is more understandable.
Below is a small table to show what the formula should achieve.

Thank you Gerald.

Serge.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M
1						New Draw +1			New Draw			New Draw
2		7	13		1st step			2nd step			3rd step
3
4	1	1	1		1	2		1	2		1	1
5	2	2	2		2	3		2	3		2	2
6	3	3	3		3	4		3	4		3	3
7	4	4	4		4	5		4	5		4	4
8	5	5	5		5	6		5	6		5	5
9	6	6	6		6	7		6	7		6	6
10	7	7	7		7	8		7			7	7
11	8	9	8		8	9		8	9		8	9
12	9	10	10		9	10		9	10		9	10
13	10	11	11		10	11		10	11		10	11
14	11	12	12		11	12		11	12		11	12
15	12	13	13		12	13		12	13		12	13
16	13	14	15		13	14		13	14		13	14
17	14	15	16		14	15		14	15		14	15
18	15	16	17		15	16		15	16		15	16
19	16	17	18		16	17		16	17		16	17
20
Sheet2

 

[serge]

Gerald,

Did you had a chance to look at the post # 15 ?

 

[markmzz]

Hi Serge,

Try this:

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th><th>N</th><th>O</th><th>P</th><th>Q</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;background-color: #C5D9F1;;">6</td><td style="text-align: center;background-color: #C5D9F1;;">34</td><td style="text-align: center;background-color: #C5D9F1;;">11</td><td style="text-align: center;background-color: #C5D9F1;;">3</td><td style="text-align: center;background-color: #C5D9F1;;">8</td><td style="text-align: center;background-color: #C5D9F1;;">36</td><td style="text-align: center;background-color: #C5D9F1;;">19</td><td style="text-align: center;background-color: #C5D9F1;;">10</td><td style="text-align: center;background-color: #C5D9F1;;">5</td><td style="text-align: center;background-color: #C5D9F1;;">2</td><td style="text-align: center;background-color: #C5D9F1;;">25</td><td style="text-align: center;background-color: #C5D9F1;;">37</td><td style="text-align: center;background-color: #C5D9F1;;">48</td><td style="text-align: center;background-color: #C5D9F1;;">3</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: center;;"></td><td style="text-align: center;;">1</td><td style="text-align: center;;">1</td><td style="text-align: center;;">1</td><td style="text-align: center;;">1</td><td style="text-align: center;;">1</td><td style="text-align: center;;">1</td><td style="text-align: center;;">1</td><td style="text-align: center;;">1</td><td style="text-align: center;;">1</td><td style="text-align: center;;">1</td><td style="text-align: center;;">1</td><td style="text-align: center;;">1</td><td style="text-align: center;;">1</td><td style="text-align: center;;">1</td><td style="text-align: center;;">1</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: center;;"></td><td style="text-align: center;;">2</td><td style="text-align: center;;">2</td><td style="text-align: center;;">2</td><td style="text-align: center;;">2</td><td style="text-align: center;;">2</td><td style="text-align: center;;">2</td><td style="text-align: center;;">2</td><td style="text-align: center;;">2</td><td style="text-align: center;;">2</td><td style="text-align: center;background-color: #C5D9F1;;">2</td><td style="text-align: center;;">2</td><td style="text-align: center;;">2</td><td style="text-align: center;;">2</td><td style="text-align: center;;">2</td><td style="text-align: center;;">2</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: center;;"></td><td style="text-align: center;;">3</td><td style="text-align: center;;">3</td><td style="text-align: center;;">3</td><td style="text-align: center;background-color: #C5D9F1;;">3</td><td style="text-align: center;;">3</td><td style="text-align: center;;">3</td><td style="text-align: center;;">3</td><td style="text-align: center;;">3</td><td style="text-align: center;;">3</td><td style="text-align: center;;">3</td><td style="text-align: center;;">4</td><td style="text-align: center;;">3</td><td style="text-align: center;;">3</td><td style="text-align: center;background-color: #C5D9F1;;">3</td><td style="text-align: center;;">3</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: center;;"></td><td style="text-align: center;;">4</td><td style="text-align: center;;">4</td><td style="text-align: center;;">4</td><td style="text-align: center;;">4</td><td style="text-align: center;;">5</td><td style="text-align: center;;">4</td><td style="text-align: center;;">4</td><td style="text-align: center;;">4</td><td style="text-align: center;;">4</td><td style="text-align: center;;">4</td><td style="text-align: center;;">5</td><td style="text-align: center;;">5</td><td style="text-align: center;;">4</td><td style="text-align: center;;">4</td><td style="text-align: center;;">5</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: center;;"></td><td style="text-align: center;;">5</td><td style="text-align: center;;">5</td><td style="text-align: center;;">5</td><td style="text-align: center;;">5</td><td style="text-align: center;;">6</td><td style="text-align: center;;">6</td><td style="text-align: center;;">5</td><td style="text-align: center;;">5</td><td style="text-align: center;background-color: #C5D9F1;;">5</td><td style="text-align: center;;">5</td><td style="text-align: center;;">6</td><td style="text-align: center;;">6</td><td style="text-align: center;;">6</td><td style="text-align: center;;">5</td><td style="text-align: center;;">6</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: center;;"></td><td style="text-align: center;background-color: #C5D9F1;;">6</td><td style="text-align: center;;">6</td><td style="text-align: center;;">6</td><td style="text-align: center;;">6</td><td style="text-align: center;;">7</td><td style="text-align: center;;">7</td><td style="text-align: center;;">7</td><td style="text-align: center;;">6</td><td style="text-align: center;;">6</td><td style="text-align: center;;">7</td><td style="text-align: center;;">8</td><td style="text-align: center;;">7</td><td style="text-align: center;;">7</td><td style="text-align: center;;">7</td><td style="text-align: center;;">8</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="text-align: center;;"></td><td style="text-align: center;;">7</td><td style="text-align: center;;">8</td><td style="text-align: center;;">7</td><td style="text-align: center;;">7</td><td style="text-align: center;background-color: #C5D9F1;;">8</td><td style="text-align: center;;">8</td><td style="text-align: center;;">8</td><td style="text-align: center;;">8</td><td style="text-align: center;;">7</td><td style="text-align: center;;">8</td><td style="text-align: center;;">9</td><td style="text-align: center;;">9</td><td style="text-align: center;;">8</td><td style="text-align: center;;">8</td><td style="text-align: center;;">9</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="text-align: center;;"></td><td style="text-align: center;;">9</td><td style="text-align: center;;">10</td><td style="text-align: center;;">9</td><td style="text-align: center;;">8</td><td style="text-align: center;;">9</td><td style="text-align: center;;">10</td><td style="text-align: center;;">9</td><td style="text-align: center;;">9</td><td style="text-align: center;;">9</td><td style="text-align: center;;">10</td><td style="text-align: center;;">11</td><td style="text-align: center;;">10</td><td style="text-align: center;;">10</td><td style="text-align: center;;">9</td><td style="text-align: center;;">10</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="text-align: center;;"></td><td style="text-align: center;;">13</td><td style="text-align: center;;">14</td><td style="text-align: center;background-color: #C5D9F1;;">11</td><td style="text-align: center;;">10</td><td style="text-align: center;;">11</td><td style="text-align: center;;">12</td><td style="text-align: center;;">11</td><td style="text-align: center;background-color: #C5D9F1;;">10</td><td style="text-align: center;;">10</td><td style="text-align: center;;">11</td><td style="text-align: center;;">12</td><td style="text-align: center;;">12</td><td style="text-align: center;;">11</td><td style="text-align: center;;">11</td><td style="text-align: center;;">12</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="text-align: center;;"></td><td style="text-align: center;;">15</td><td style="text-align: center;;">16</td><td style="text-align: center;;">15</td><td style="text-align: center;;">16</td><td style="text-align: center;;">17</td><td style="text-align: center;;">18</td><td style="text-align: center;;">13</td><td style="text-align: center;;">12</td><td style="text-align: center;;">13</td><td style="text-align: center;;">14</td><td style="text-align: center;;">15</td><td style="text-align: center;;">13</td><td style="text-align: center;;">13</td><td style="text-align: center;;">12</td><td style="text-align: center;;">13</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="text-align: center;;"></td><td style="text-align: center;;">24</td><td style="text-align: center;;">25</td><td style="text-align: center;;">17</td><td style="text-align: center;;">18</td><td style="text-align: center;;">19</td><td style="text-align: center;;">20</td><td style="text-align: center;background-color: #C5D9F1;;">19</td><td style="text-align: center;;">14</td><td style="text-align: center;;">15</td><td style="text-align: center;;">16</td><td style="text-align: center;;">17</td><td style="text-align: center;;">16</td><td style="text-align: center;;">14</td><td style="text-align: center;;">14</td><td style="text-align: center;;">15</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style="text-align: center;;"></td><td style="text-align: center;;">25</td><td style="text-align: center;;">26</td><td style="text-align: center;;">26</td><td style="text-align: center;;">27</td><td style="text-align: center;;">28</td><td style="text-align: center;;">29</td><td style="text-align: center;;">21</td><td style="text-align: center;;">22</td><td style="text-align: center;;">23</td><td style="text-align: center;;">24</td><td style="text-align: center;background-color: #C5D9F1;;">25</td><td style="text-align: center;;">18</td><td style="text-align: center;;">17</td><td style="text-align: center;;">15</td><td style="text-align: center;;">16</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="text-align: center;;"></td><td style="text-align: center;;">26</td><td style="text-align: center;;">27</td><td style="text-align: center;;">27</td><td style="text-align: center;;">28</td><td style="text-align: center;;">29</td><td style="text-align: center;;">30</td><td style="text-align: center;;">30</td><td style="text-align: center;;">31</td><td style="text-align: center;;">32</td><td style="text-align: center;;">33</td><td style="text-align: center;;">34</td><td style="text-align: center;;">35</td><td style="text-align: center;;">19</td><td style="text-align: center;;">18</td><td style="text-align: center;;">19</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="text-align: center;;"></td><td style="text-align: center;;">31</td><td style="text-align: center;;">32</td><td style="text-align: center;;">28</td><td style="text-align: center;;">29</td><td style="text-align: center;;">30</td><td style="text-align: center;;">31</td><td style="text-align: center;;">31</td><td style="text-align: center;;">32</td><td style="text-align: center;;">33</td><td style="text-align: center;;">34</td><td style="text-align: center;;">35</td><td style="text-align: center;;">36</td><td style="text-align: center;;">36</td><td style="text-align: center;;">20</td><td style="text-align: center;;">21</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="text-align: center;;"></td><td style="text-align: center;;">33</td><td style="text-align: center;background-color: #C5D9F1;;">34</td><td style="text-align: center;;">33</td><td style="text-align: center;;">34</td><td style="text-align: center;;">35</td><td style="text-align: center;background-color: #C5D9F1;;">36</td><td style="text-align: center;;">32</td><td style="text-align: center;;">33</td><td style="text-align: center;;">34</td><td style="text-align: center;;">35</td><td style="text-align: center;;">36</td><td style="text-align: center;background-color: #C5D9F1;;">37</td><td style="text-align: center;;">37</td><td style="text-align: center;;">37</td><td style="text-align: center;;">38</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style="text-align: center;;"></td><td style="text-align: center;;">36</td><td style="text-align: center;;">37</td><td style="text-align: center;;">38</td><td style="text-align: center;;">39</td><td style="text-align: center;;">40</td><td style="text-align: center;;">41</td><td style="text-align: center;;">42</td><td style="text-align: center;;">43</td><td style="text-align: center;;">44</td><td style="text-align: center;;">45</td><td style="text-align: center;;">46</td><td style="text-align: center;;">47</td><td style="text-align: center;background-color: #C5D9F1;;">48</td><td style="text-align: center;;">38</td><td style="text-align: center;;">39</td><td style="text-align: center;background-color: #C5D9F1;;">CF   =B6=C$4</td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="text-align: center;;">****</td><td style="text-align: center;;">****</td><td style="text-align: center;;">****</td><td style="text-align: center;;">****</td><td style="text-align: center;;">****</td><td style="text-align: center;;">****</td><td style="text-align: center;;">****</td><td style="text-align: center;;">****</td><td style="text-align: center;;">****</td><td style="text-align: center;;">****</td><td style="text-align: center;;">****</td><td style="text-align: center;;">****</td><td style="text-align: center;;">****</td><td style="text-align: center;;">****</td><td style="text-align: center;;">****</td><td style="text-align: center;;">****</td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Number</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C6</th><td style="text-align:left">=IF(<font color="Blue">ROW(<font color="Red"></font>)=6,1,IF(<font color="Red">(<font color="Green">ROW(<font color="Purple"></font>)-ROW(<font color="Purple">$5:$5</font>)</font>)<=MATCH(<font color="Green">C$4,B$6:B$21,0</font>),B5+1,B6+1</font>)</font>)</td></tr></tbody></table></td></tr></table><br />
Markmzz

 

[serge]

Mark,

I don't know how to thank you for this one, you did solve this formula problem for me, which I needed so bad.
Incredible work, Thank you so much.

Serge.

 

[markmzz]

Mark,

I don't know how to thank you for this one, you did solve this formula problem for me, which I needed so bad.
Incredible work, Thank you so much.

Serge.

Serge,

I'm happy that your problem was solved.

And thanks for the feedback.

Markmzz