copy formula every x rows

[Guest]

i have a formula like this:

column m
row 4 =text(h4,"yymmdd")&" "&g4

row 8 copy formula

row 12 copy formula

row 16 copy formula



can someone let me know how to copy the formula in this sequence

thanks a lot

 

[Guest]

Try this:

=IF(MOD(ROW(),4)=0,TEXT(H4,"yymmdd")&" "&G4,"")

It will put "" in column M for each row that isn't in your selection. If
that's not acceptable, let me know.

 

[Guest]

With your formula in say M4 / M8 / M12 / M16

select M4:M19 (Note the cell is the last empty cell before you would next
have a formula, then grab the the little black cross at the bottom right of
your selection and drag down.

 

[Guest]

THANKS A LOT

With your formula in say M4 / M8 / M12 / M16

select M4:M19 (Note the cell is the last empty cell before you would next
have a formula, then grab the the little black cross at the bottom right of
your selection and drag down.

 

[Guest]

THANKS A LOT

Try this:

=IF(MOD(ROW(),4)=0,TEXT(H4,"yymmdd")&" "&G4,"")

It will put "" in column M for each row that isn't in your selection. If
that's not acceptable, let me know.

 

[Ken Wright]

You're welcome

THANKS A LOT