copy formula every x rows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

andresg1975 - 30 Oct 2006 15:34 GMT

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

Reply to this Message

Barb Reinhardt - 30 Oct 2006 15:49 GMT

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.

> i have a formula like this:
>
[quoted text clipped - 10 lines]
>
> thanks a lot

Reply to this Message

andresg1975 - 30 Oct 2006 17:23 GMT

THANKS A LOT

> Try this:
>
[quoted text clipped - 17 lines]
> >
> > thanks a lot

Reply to this Message

Ken Wright - 30 Oct 2006 15:50 GMT

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.

Signature

Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------
It's easier to beg forgiveness than ask permission :-)

> i have a formula like this:
>
[quoted text clipped - 10 lines]
>
> thanks a lot

Reply to this Message

andresg1975 - 30 Oct 2006 17:23 GMT

THANKS A LOT

> With your formula in say M4 / M8 / M12 / M16
>
[quoted text clipped - 16 lines]
> >
> > thanks a lot

Reply to this Message

Ken Wright - 30 Oct 2006 23:32 GMT

You're welcome :-)

> THANKS A LOT
>
[quoted text clipped - 20 lines]
>> >
>> > thanks a lot

Reply to this Message