sequence numbers like 1 2 1 2 1 2

[udprocks]

Gud evening All,


Again I have a query can anyone please help me out with this.

I want to put serial numbers like 1 2 1 2 1 2 1 2 1 2 1 2 in a column is this possible ? with any formula, because I have to do it till approx. 8000 numbers.

Have also attached a sample file,

Thanks in advance.

 

[tomas]

Hi

in the attachement

 

[jayalaxmi]

here is the other one

 

[udprocks]

Hi

in the attachement

Thanks a lot tomas,

for your support.

 

[Khalid NGO]

another:
=IF(MOD(ROW(A1),2)=0,2,1)

Regards,

 

[Deepak]

Hi,

I don't think that if involvement is required here..

Check this..

=1+ISEVEN(ROW(A1))

 

[Khalid NGO]

Hi,

I don't think that if involvement is required here..

Check this..

=1+ISEVEN(ROW(A1))

Good idea Deepak Sir,

Thought to update my formula without IF:
=2-MOD(ROW(A1),2)

Regards,