Hi,

I don't think you can do this directly (or at least I couldn't get it to
work!). The two ways I found are to use either =OFFSET() or =INDIRECT().
Create a column with 2, 4, 6, ... in it (which you can drag down correctly).
Let's say this is column D. Then the formula


"Anant" wrote:

Hi everybody,
I am new to Excel and have a simple question about patterns in formulas. I
have a column like this:

=A2
=A4
=A6

How can I simply do a drag or something to continue that forumla pattern all
the way throughout the spreadsheet? I know if you just had A2 and dragged it
from the lower right corner, you'd see A3, A4, A5 below it. Also, I have a
column like this:

=RANK(C2,C:C)
=RANK(C4,C:C)
=RANK(C4,C:C)

Again, how can I simply continue this pattern for many rows? Thanks!!!