Thread: sequence
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Earl Kiosterud Earl Kiosterud is offline
external usenet poster
 
Posts: 611
Default sequence

Cesar,

I'm not at all sure what the 1 to 52 weeks, or the days 20 to 21 have to do
with anything. But to repeat the sequence you gave for C, D and E, select
the three cells. Drag the fill handle down, holding Ctrl.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"cesar" wrote in message
...
column A - num week(1 to 52), column B - day 20 to 21 next month.how can
create on column C, D, E, in sequential 1 on column C, 2 on column D and 3
on
column E for week 44. but chage in order in week 45 and all next in same
order.
C D E
1 2 3
2 3 1
3 1 2
continue in next weeks of next years.
tanks for replay!