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#a9915684 Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]