On Tue, 12 Jan 2010 09:49:22 -0800 (PST), Yanick
wrote:

On Jan 12, 12:15*pm, StevenH
wrote:
I want to auto fill a colum as shown
1
1
2
2
3
3
4
4 * ect ect but everytime i do it i end up getting decimals. or sometimes
ill get 3 of a number instead, is there a way to fix this.

Assuming you start at cell A1, put 1 in A1 & A2 then put =IF(SUM(A1:A2)
=A2*2,A2+1,A2) in A3 then drag it down. Just have to copy / paste
value the column to complete the trick.


If you want a shorter formula, try the following in A3:

=A2+(A2=A1)

Hope this helps / Lars-Åke