If your formulas start in cell A3, for example, and you want to pull from
row 10, 111, 212, etc of column B, then in cell A3 use the formula

=INDIRECT("B" & (ROW()-ROW($A$3))*101+10)

and copy down as far as you need.

HTH,
Bernie
MS Excel MVP


"AccountantPB" wrote in message
...
How do I reference the formula above and get the result off 101 rows below
that formula? I need to reference every 101 st row but put the
information
one row on top of each other.

Thanks