copy formula every x rows

A

andresg1975

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
 
B

Barb Reinhardt

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.
 
K

Ken Wright

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.
 
A

andresg1975

THANKS A LOT

Ken Wright said:
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.
Click to expand...
 
A

andresg1975

THANKS A LOT

Barb Reinhardt said:
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.
Click to expand...
 
Top