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.