Formula Fill Problems
Jim,
This method works! Thank you very much. I'll just need to leave enough room
so that when new rows are entered I can use this method without over running
into other data.
Thank you again for your out-of-the-box thinking!
excelBRISKbaby
"Jim Rech" wrote:
Cell references always increment by 1 so you have to approach this
differently. This works I think:
-Enter your first formula in A1
-Select A1:A3 and drag the fill handle until you have all the formulas you
want
-With the range still selected do a {F5}, Special, Blanks, OK
-Press Ctrl-Minus and select Shift Cells Up.
--
Jim
"excelBRISKbaby" wrote in message
...
|I have a formula that I want to implement for a series of data points. For
| the first cell(A1) the formula would be "IF(E5=0, NA(), E6/E5)" The next
cell
| in the series (A2) would be "IF(E8=0, NA(), E9/E8)". So each time the
formula
| is iterated it increases each cell value by three. So, continuing the
example
| the next cell (A3) would contain "IF(E11=0, NA(), E12/E11)".
|
| However, when I try the click-fill method it iterates by 1. I also cannot
| have excel do this using the Edit -Fill- Series method either.
|
| How may I iterate formulas by values different than 1?
|
| excelBRISKbaby
|