how do i...

[LSB M]

I have 10 columns: A1:J1

I would like to deposit a value (actually, a formula) every "X" interval. So if I specify "2", I would like to deposit this value every "2" columns in the array A1:J1. If I enter "3", every 3 columns, etc.

Would appreciate any help...


Thanks!

[Ragdyer]

Say that you enter a value *or* a formula in A11.
This will be the *value displayed* in the A1 to J1 array.

Say you enter a formula *or* a value in A10.
This will be the *interval* to repeat the value from A11 into the A1:J1
array.

Now, enter this formula in A1 and copy across to J1, *or further* if
necessary:

=(MOD(COLUMN(),$A$11)=0)*$A$10


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"LSB M" <[email protected]> wrote in
message news:[email protected]...
>
> I have 10 columns: A1:J1
>
> I would like to deposit a value (actually, a formula) every "X"
> interval. So if I specify "2", I would like to deposit this value
> every "2" columns in the array A1:J1. If I enter "3", every 3 columns,
> etc.
>
> Would appreciate any help...
>
>
> Thanks!
>
>
> --
> LSB M
> ------------------------------------------------------------------------
> LSB M's Profile:
> http://www.excelforum.com/member.php...o&userid=36258
> View this thread: http://www.excelforum.com/showthread...hreadid=563534
>

[LSB M]

RD, I didn't know that there's a modulo function in excel. Cool!

Thanks so much for your help, really appreciate it.

[Ragdyer]

You're welcome, and thank you for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"LSB M" <[email protected]> wrote in
message news:[email protected]...
>
> RD, I didn't know that there's a modulo function in excel. Cool!
>
> Thanks so much for your help, really appreciate it.
>
>
> --
> LSB M
> ------------------------------------------------------------------------
> LSB M's Profile:
> http://www.excelforum.com/member.php...o&userid=36258
> View this thread: http://www.excelforum.com/showthread...hreadid=563534
>