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.

Supposing that you want every 2nd value from column A, starting with A2,
in column B from B2 downwards...

In B2 enter & copy down as far as needed:

=INDEX(A:A,CELL("Row",$A$2)+(ROW()-ROW(B$2))*2)

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

Supposing that you want to rank every 2nd value from column C, starting
with C2...

In D2 enter & copy down as far as needed:

=INDEX(C:C,CELL("Row",$C$2)+(ROW()-ROW(D$2))*2)

In E1 enter:

=LOOKUP(2,1/ABS($D$2:INDEX($D:$D,MATCH(9.99999999999999E+305,$ D:$D))0),

ROW($D$2:INDEX($D:$D,MATCH(9.99999999999999E+305,$ D:$D))))-CELL("Row",$D$2)+1

In D2 enter & copy down:

=IF(ROW()-ROW(D$2)+1<=$E$1,RANK(D2,$D$2:INDEX(D:D,$E$1+CELL( "Row",$D$2)-1)),"")