Create Pattern Numbers

[ryan8200]

Anyone know how to create pattern numbers like 1,1,,2,2,1,1,2,2 ?

 

[jbeaucaire]

Enter the first 4 values in the first 4 cells.

A1: 1
A2: 1
A3: 2
A4: 2

Then in A5 put this formula and copy the cell downward as far as needed:

A5: =A1

 

[ryan8200]

Thanks for the quick reply. Is that possible to use function MOD and INT to create this particular pattern numbers?

 

[jbeaucaire]

Why would you want to? Never substitute a simple answer for a complex one "just because". It would need to serve a meaningful purpose.

 

[Ruddles]

I agree 100% with the last post. However, for the mental exercise, yes it is possible to use INT and MOD. Put this in A1 and copy down:-

=CHOOSE(INT(MOD(ROW(),4)+1),2,1,1,2)

Simple is almost always best though.

 

[ryan8200]

Thanks for your code

 

[pgc01]

Hi

I agree with Jerry, if you have a simple solution use it.

Just for the fun, another one, in A1 and copy down:

=1+ISODD((ROW()-1)/2)

 

[jbeaucaire]

Rube Goldberg formulas are born!