In Excel, how to fill down consecutive integers following a pattern 1, 1, 2, 2,

I don't think Excel includes the logic to do this, although I'll be happy to be proved wrong.

A workaround would be to use a formula copied down the column, then use PasteSpecial>Values to overwrite with the desired values.

   A       B        C
1  1
2  1
3  =A1+1
4  =A2+1
5  =A3+1

etc.


No Excel here, but in OpenOffice.org, filling down the following value and formula:

      A
1     1
2   =A1

...gets me new values and formulas:

      A
1     1
2   =A1
3     2
4   =A3
5     3
6   =A5
7     4
8   =A7

...which displays as you want it to.


For a pure formula version,

=ROUNDUP(ROW(A1)/2,0) will fill down correctly. (If starting further down than row 1, subtract as needed.)