Formula fill...

  • Thread starter Thread starter Melissa
  • Start date Start date
M

Melissa

Hello,
I used to do tech support for Microsoft. I remember
someone building a formula that allowed you to vertically
and reference a horizontal range. For instance, you could
fill from a1 to a10 and reference b2 to b11. Does anyone
know how to do this?

Thanks!
 
Not sure this is what you're looking for, but if you put this in A1:

=B2 + 1

then copy A1 down to A10, XL will reference as follows:

A2: =B3 + 1
A3: =B4 + 1
....
A10 =B11 + 1
 
In your particular example, put this in A1 and fill down:

=OFFSET($A$1,,ROW())

HTH
Jason
Atlanta, GA
 
Oops...not thinking straight. I was thinking B2:K2. Just
use =B2 in A1 and fill down.

Jason
 
Cool! Thanks! That's exactly what I needed!
-----Original Message-----
In your particular example, put this in A1 and fill down:

=OFFSET($A$1,,ROW())

HTH
Jason
Atlanta, GA

.
Click to expand...
 
Back
Top