You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Josh W" wrote in message
...
Thanks Biff, works perfectly.

"T. Valko" wrote:

One way...

Entered in A1 and copied down as needed:

=CEILING(ROWS(A$1:A1)/3,1)

--
Biff
Microsoft Excel MVP


"Josh W" wrote in message
...
Please help create a formula/shortcut for the following:
A1=1
A2=1
A3=1
A4=2
A5=2
A6=2
A7=3
A8=3
A9=3
And so on, each number in increment of three, all the way down. Thanks.
Excel 2003