LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tom Tom is offline
external usenet poster
 
Posts: 49
Default How to line up two dates?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Line Chart for Dates Brw Charts and Charting in Excel 1 November 20th 08 02:05 PM
remove dates is the middle of a line jason2444 Excel Discussion (Misc queries) 2 June 20th 07 03:55 AM
Column-Line Chart w/ Dates Neutron1871 Charts and Charting in Excel 4 September 26th 06 06:51 PM
multi-line graph with dates on x-axis Ef Charts and Charting in Excel 4 January 29th 06 12:19 AM
Dates to number in edit line Skip4t4 Excel Worksheet Functions 5 April 21st 05 05:08 PM


All times are GMT +1. The time now is 11:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"