fill multiple cell references

[Shaun]

I am using relative cell references, but within my column
I have this

in cell: a1 =b1
a2 =c1

and what I would like to be able to do is fill in so that
I have

in cell: a1 =b1
a2 =c1
a3 =b2
a4 c2
etc.

but when I highlight the first two rows and pull the fill
handle I get

in cell: a1 =b1
a2 =c1
a3 =b3
a4 =c3
etc.

Any thoughts?

thank you.

 

[Frank Kabel]

Hi
enter the following in A1
=OFFSET($B$1,INT((ROW()-1)/2),MOD(ROW()-1,2))

and copy this down

 

[Guest]

thank you for the response,

Now how would I be able to fill in two cells with the same
reference

in cell: a1 =b1
a2 =b1
a3 =b2
a4 =b2

thanks again

 

[Frank Kabel]

Hi
use the following in A1:
=OFFSET($B$1,INT((ROW()-1)/2),0)