I was distracted in this by what seemed to be a bug. I could not get the original formula to work without <>0. It should have. After checking with others, who confirm that the <>0 is unnecessary, I find that the formula does, indeed, not require <>0.
The elves which seem to bedevil my computer must have been making mischief again yesterday. I tested the issue several times, so it can't have been me. ¿¿¿? =IF(MOD(ROW()-ROW($A$1)+$A$1;2);ROW()-ROW($A$1)+$A$1;"") TerryJ wrote: > > My bad. Sorry. I shouldn't have assumed that A1 was the start: (third > time lucky) > =IF(MOD(ROW()-ROW($A$1)+$A$1;2)<>0;ROW()-ROW($A$1)+$A$1;"") > > > TerryJ wrote: >> >> I shouldn't have taken 1 as the inevitable beginning: >> =IF(MOD(ROW();2)<>0;ROW()-ROW($A$1)+$A$1;"") >> >> >> TerryJ wrote: >>> >>> I am always intrigued by questions like this. Assuming your start cell >>> is A1, enter the following formula in A2 and drag it down: >>> =IF(MOD(ROW();2)<>0;ROW()-ROW($A$1)+1;"") >>> >>> >>> Joe Conner wrote: >>>> >>>> Yes. In cell A1 enter 1. >>>> In cell A3 enter =A1+1 >>>> Click on cell A2. >>>> Holding down the shift key, >>>> press the down arrow 2 times. >>>> This will paint cells A2, A3. >>>> Copy (CTRL C). >>>> Click on cell A4. >>>> Hold down the shift key. >>>> Press CTRL and Down Arrow >>>> Paste (CTRL V). >>>> There you have it. >>>> >>>> Joe Conner, Poulsbo, WA USA >>>> >>>> >>>> >>>> Kirill S. Palagin wrote: >>>>> Hello. >>>>> >>>>> Is there a (non-macro) way to generate fill series skipping every >>>>> second >>>>> row with increment >1? >>>>> That is I want result to be like "1, blank, 3, blank, 5, blank, 7". >>>>> >>>>> Thanks a lot. >>>>> WBR, >>>>> K. Palagin. >>>>> >>>>> >>>> >>>> --------------------------------------------------------------------- >>>> To unsubscribe, e-mail: [EMAIL PROTECTED] >>>> For additional commands, e-mail: [EMAIL PROTECTED] >>>> >>>> >>>> >>> >>> >> >> > > -- View this message in context: http://www.nabble.com/Calc---Fill-series---filling-every-second-row-with-increment%3E1---tf3551502.html#a9931578 Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
