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