View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg
 
Posts: n/a
Default 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)