Continue the calculation but stops at 99 *

[DocAElstein]

Hi Learning,
If I change the spacing to 3 and the limit to 600, I get this:

Values that you see:

Using Excel 2007 32 bit

Row\Col	A	B	C	D	E	F	G	H	I	J
1	Spacing	3
2	Start	120					121	124		1
3	Limit	600					125	128		2
4			121	124	1		129	132		3
5			125	128	2		133	136		4
6			129	132	3		137	140		5

Worksheet: Sheet1





Using Excel 2007 32 bit

Row\Col	B	C	D	E	F	G	H	I	J	K
117		573	576	114		581	584		116
118		577	580	115		585	588		117
119		581	584	116		589	592		118
120		585	588	117		593	596		119
121		589	592	118		597	600		120
122		593	596	119
123		597	600	120
124
125

Worksheet: Sheet1



Formulas

Using Excel 2007 32 bit

Row\Col	A	B	C	D	E	F	G	H	I	J
1	Spacing	3
2	Start	120					=$B$2+1	=IF(G2="","",G2+$B$1)		=IF(G2="","",J1+1)
3	Limit	600					=IF(H2>=$B$3,"",D4+1)	=IF(G3="","",G3+$B$1)		=IF(G3="","",J2+1)
4			=$B$2+1	=IF(C4="","",C4+$B$1)	=IF(C4="","",E3+1)		=IF(H3>=$B$3,"",H3+1)	=IF(G4="","",G4+$B$1)		=IF(G4="","",J3+1)
5			=IF(D4>=$B$3,"",H2+1)	=IF(C5="","",C5+$B$1)	=IF(C5="","",E4+1)		=IF(H4>=$B$3,"",H4+1)	=IF(G5="","",G5+$B$1)		=IF(G5="","",J4+1)
6			=IF(D5>=$B$3,"",H3+1)	=IF(C6="","",C6+$B$1)	=IF(C6="","",E5+1)		=IF(H5>=$B$3,"",H5+1)	=IF(G6="","",G6+$B$1)		=IF(G6="","",J5+1)

Worksheet: Sheet1



Using Excel 2007 32 bit

Row\Col	B	C	D	E	F	G	H	I	J	K
117		=IF(D116>=$B$3,"",H114+1)	=IF(C117="","",C117+$B$1)	=IF(C117="","",E116+1)		=IF(H116>=$B$3,"",H116+1)	=IF(G117="","",G117+$B$1)		=IF(G117="","",J116+1)
118		=IF(D117>=$B$3,"",H115+1)	=IF(C118="","",C118+$B$1)	=IF(C118="","",E117+1)		=IF(H117>=$B$3,"",H117+1)	=IF(G118="","",G118+$B$1)		=IF(G118="","",J117+1)
119		=IF(D118>=$B$3,"",H116+1)	=IF(C119="","",C119+$B$1)	=IF(C119="","",E118+1)		=IF(H118>=$B$3,"",H118+1)	=IF(G119="","",G119+$B$1)		=IF(G119="","",J118+1)
120		=IF(D119>=$B$3,"",H117+1)	=IF(C120="","",C120+$B$1)	=IF(C120="","",E119+1)		=IF(H119>=$B$3,"",H119+1)	=IF(G120="","",G120+$B$1)		=IF(G120="","",J119+1)
121		=IF(D120>=$B$3,"",H118+1)	=IF(C121="","",C121+$B$1)	=IF(C121="","",E120+1)		=IF(H120>=$B$3,"",H120+1)	=IF(G121="","",G121+$B$1)		=IF(G121="","",J120+1)
122		=IF(D121>=$B$3,"",H119+1)	=IF(C122="","",C122+$B$1)	=IF(C122="","",E121+1)		=IF(H121>=$B$3,"",H121+1)	=IF(G122="","",G122+$B$1)		=IF(G122="","",J121+1)
123		=IF(D122>=$B$3,"",H120+1)	=IF(C123="","",C123+$B$1)	=IF(C123="","",E122+1)		=IF(H122>=$B$3,"",H122+1)	=IF(G123="","",G123+$B$1)		=IF(G123="","",J122+1)
124		=IF(D123>=$B$3,"",H121+1)	=IF(C124="","",C124+$B$1)	=IF(C124="","",E123+1)		=IF(H123>=$B$3,"",H123+1)	=IF(G124="","",G124+$B$1)		=IF(G124="","",J123+1)
125		=IF(D124>=$B$3,"",H122+1)	=IF(C125="","",C125+$B$1)	=IF(C125="","",E124+1)		=IF(H124>=$B$3,"",H124+1)	=IF(G125="","",G125+$B$1)		=IF(G125="","",J124+1)

Worksheet: Sheet1




Alan

P.s. I left the original data in , ( moved across by one column ) for no particular reason - it was just useful to check the final results