Auto fill

[StevenH]

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.

 

[Yanick]

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.

 

[Dave Peterson]

I'd use a formula.

If it's starting in row 1:
=INT((ROW()-1)/2)+1

 

[Lars-Åke Aspelin]

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