Hi,

Here is one solution:

=INT(ROW(3:3)/3)


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"NAKA" wrote:

I'm trying trying to create a column of number in a pattern:
1,1,1,2,2,2,3,3,3 etc. When I use the drag and fill option to continue this
pattern, it inserts extra rows and included decimals. How do I prevent this?