Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Before I can carry out other task, I have to line up the row where Date 1
starts with Date 2 for all other stocks. It is not always 3 rows down as shown below. How would you write the codes to do that? Thanks. Code Date 1 Date 2 ABW 20090106 5.85 5.85 5.85 5.85 242 20090101 ABW 20090107 5.91 5.91 5.91 5.91 2000 20090102 ABW 20090108 5.85 5.85 5.85 5.85 2380 20090105 ABW 20090109 5.8 5.8 5.8 5.8 3468 20090106 ABW 20090112 5.9 5.97 5.9 5.97 4696 20090107 ABW 20090113 5.93 5.93 5.93 5.93 2993 20090108 20090109 20090112 20090113 Code Date 1 Date 2 20090101 20090102 20090105 ABW 20090106 5.85 5.85 5.85 5.85 242 20090106 ABW 20090107 5.91 5.91 5.91 5.91 2000 20090107 ABW 20090108 5.85 5.85 5.85 5.85 2380 20090108 ABW 20090109 5.8 5.8 5.8 5.8 3468 20090109 ABW 20090112 5.9 5.97 5.9 5.97 4696 20090112 ABW 20090113 5.93 5.93 5.93 5.93 2993 20090113 TIA Tom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Line Chart for Dates | Charts and Charting in Excel | |||
remove dates is the middle of a line | Excel Discussion (Misc queries) | |||
Column-Line Chart w/ Dates | Charts and Charting in Excel | |||
multi-line graph with dates on x-axis | Charts and Charting in Excel | |||
Dates to number in edit line | Excel Worksheet Functions |