Formula fill...

[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!

 

[J.E. McGimpsey]

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

 

[Jason Morin]

In your particular example, put this in A1 and fill down:

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

HTH
Jason
Atlanta, GA

 

[Jason Morin]

Oops...not thinking straight. I was thinking B2:K2. Just
use =B2 in A1 and fill down.

Jason

 

[Guest]

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

.