Semi Annual Counter
Reduced to a general case, the task is to convert the
series {1,2,3,....,12} into
1 2 1 2 1 2 1 2 1 2 1 2
1 1 2 2 1 1 2 2 1 1 2 2
1 1 1 1 1 1 2 2 2 2 2 2
given a key of 2, 4 or 12.
For each row and its key, enter this array formula
=CEILING((MOD(series-1,key)+1)/key*2,1)
|