Formula referencing rows formula below

Anyone know how to create a formula tied to a rows formula that calculates on figures generated by a rows formula below it? My problem is that the top rows formula expands first and then the rows formula below it expands next. So the formula in the first rows formula only references to the first row of the second rows formula.

For example:

Column A Column B Column C
Row1 Nl("rows","GL00100","Accindx","100..200") Balance 9/30/08 (B1-B2)/B2
Row2 Nl("rows","GL00100","Accindx"."100..200") Balance 8/31/08

When this report is run, then the following happens:

Row1 100 $500 25.00% - correctly calculated as ($500-$400)/$400
Row2 200 $350 16.67% - incorrectly calculated as ($350-$300)/$300, should be (($350-$200)/$200
Row3 100 $300
Row4 200 $200

Because Row1 expands into Row1 and Row2 before Row2 expands into Row3 and Row4, the formula in C1 becomes (B1-B3)/B3, and in C2 becomes (B2-B3)/B3, instead of (B2-B4)/B4, you know?