Help with formula
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
|