how do i...

L

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 valu
every "2" columns in the array A1:J1. If I enter "3", every 3 columns
etc.

Would appreciate any help...


Thanks
 
R

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
 
L

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. :)
 
Top