Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i...
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i...
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i...
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i...
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|