Formula fill...

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

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
 
J

Jason Morin

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

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

HTH
Jason
Atlanta, GA
 
J

Jason Morin

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

Jason
 
G

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

.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top