Drop Down Duplication

[VictorBravoAsshat]

Hello,
For the life of me, I can't figure this out. Hopfully I'm doing something stupid and someone can assist.

I'm looking to copy a cell twice then the next cell twice, going down about 30 original cells
=h3
=h3
=h4
=h4
.
.
.
=h30
=h30

When I drag down, it puts =h7, =h7, =h8m, =h8, =h11, =h11, missing h5, h6, then h9, h10.

Can someone shed some light for me please?
Thank you

 

[AlphaFrog]

Try this...

=INDEX($H$3:$H$30, INT(ROW(H2)/2))

 

[VictorBravoAsshat]

=INDEX($H$3:$H$30, INT(ROW(H2)/2))

Thank you AlphaFrog!

That worked like a charm! Wish I could find a page of these nifty little formulas.

I Appreciate your quick response.