Basic Fill Handle

[jhct]

Hi, here's a plain example of what I'm trying to do:
In cell B1 is the formula: =A1
In cell B2 is the formula: =A1
In cell B3 is the formula: =A2
In cell B4 is the formula: =A2
In cell B5 is the forumla: =A3
In cell B6 is the formula: =A3

(we can see where this is heading..)

The problem I have is that I want to use the fill handle to copy this
series down a whole column, however Excel just won't see the pattern
here! (or I'm missing something obvious)

Help please!!!!

 

[Biff]

Hi!

Enter this formula in B1 and copy down as needed:

=INDEX(A:A,CEILING(ROWS($1:1)/2,1))

Biff

 

[Arvi Laanemets]

Hi

Another formula

B1=OFFSET($A$1,INT((ROW()-1)/2),)


Arvi Laanemets

 

[hansyt]

Select cells B1 and B2, grab the autofill handle and drag down as
required.

Hans