sequential numbering 1,1,2,2,3,3

[muhammad susanto]

hi all...
how to sequential numbering like this :
1
1
2
2
3
3
etc..

any help...thanks so much

m.susanto

 

[Rick Rothstein]

Give this formula a try...

=ROUNDUP(ROWS($N:N)/2,0)

where you would substitute the row number you are putting the formula in initially for both of the N's.

 

[footoo]

Put 1 in A1 & A2, Select Ai:A2 and drag down.

Or put in A1 and drag down : =ROUNDUP(ROW()/2,0)

 

[Peter_SSs]

Put 1 in A1 & A2, Select Ai:A2 and drag down.

That just produces all 1's for me.

Other options..
a) Manually put a 1 in A1 & A2 then in A3: =A1+1 and copy A3 down

b) Put a 1 in A1 then in A2, copied down, =A1+MOD(ROWS(A$1:A2),2)

 

[footoo]

That just produces all 1's for me.
Manually put a 1 in A1 & A2 then in A3: =A1+1 and copy A3 down

That's what I meant to post!