copy formula every x rows
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.
"andresg1975" wrote:
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
|