Can Excel produce a strange but logical sequence of numbers?

Excel only recognizes arithmetic patterns.

In your case, you can define a formula and fill it to the needed rows.

=A1 + IF(MOD(ROW(), 3) = 0, 1, 2)

Change A1 to the cell where your sequence starts.

In this screen shot below, A1 has the value 14. In A2 I entered this formula

=A1 + IF(MOD(ROW(),3)=0,1,2)

And copied it down

enter image description here


Excel supports arithmetic patterns with step size >1 Fill in the first 3 values, and then use a pattern from there down

  1. 14
  2. 16
  3. 17
  4. =A1+5

and then copy that down. I.e. A5 becomes =A2+5 which is indeed 21.


Assuming you start at row 1, it's =ROUND((ROW()*5+37)/3,0)

For every 3 rows, you add 5, hence 5/3. The 37 is to get the starting value right (row 1 => value 14). ROUND to two digits to see how it works.


I really like the intuition behind the already posted answers but it seems everyone is overlooking the simplest solution built into excel.

  • Just type 14 in cell A1

  • in A2 type =A1 + 2

  • in A3 type =A2 + 1

  • in A4 type =A3 + 2

  • select cells A2, A3 and A4 and drag the fill handle in the bottom right corner to the desired point. Excel will indeed repeat the formulas as typed.

Edit: Just to add, although the OP's question is arithmetic in nature and can be tackled with elegant mathematical solutions, if someone comes across this with any other non-mathematical formulas they want to repeat in this fashion, any conditional math would just clutter and slow down the sheet.