Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sequence
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sequence
layout of sheet: for this month: B7 - 21/Out/2006 to B37 - 20/Nov/2006, for
next month: B7 - 21/Nov/2006 to B37 - 20/Dec/2006, or next B7 - 21/Dec/2006 to B37 - 20/Jan/2007. the date is changed only i chnge month in list box. in auto in C9:C15 = 1 (23/Out/06 to 29/Out/06 = week 43) and D9:D15 =2, and E9:E15 = 3. C D E 1 2 3 - week 43 2 3 1 - week 44 3 1 2 - week 45 ... and all next weeks "Earl Kiosterud" escreveu: 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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sequence need help for this
"cesar" escreveu: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
min and max in a sequence | Excel Worksheet Functions | |||
HOW DO I FORMAT WORKSHEETS IN A WORKBOOK TO NUMBER IN A SEQUENCE? | Excel Worksheet Functions | |||
text & number sequence | Excel Worksheet Functions | |||
Sequence Formula | Excel Worksheet Functions | |||
How to look for a sequence of numbers in a string? | Excel Discussion (Misc queries) |