Actually, a slightly more simple formula... assuming Row 3 is the starting row, place a 1 in R3 and then use this formula in R4 and then copy it down as far as you want:

=1+MOD(R3,2)

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message ...
Put this formula in your "starting" cell in Column R (cell R3 from your example) and copy it down as far as you want...

=1+MOD(ROW(A2),2)

--
Rick (MVP - Excel)


"Aussie Bob C" wrote in message ...
Hi

Can I filldown column Q starting at Q3 the recurring numbers 121212 down to
lastcell in column R.

Example:
Cell
Q3 - 1
Q4 - 2
Q5 - 1
Q6 - 2
Q7 - 1
Q8 - 2

TIA
--
Thank you

Aussie Bob C
Little cost to carry knowledge with you.