Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
get data in sequence
in column A , i have dates
in column B , i have ibm stock value in column C , i have nasdaq index values now , when return from nasdaq was 0 , only for those months i want to be able to see both the ibm values and nasdaq values with the dates. my prob is : if data starts from jan 03 and in mar 03 and april 03 , nasdaq was -6 , -4 and ibm was 3 and 6 ... i want to be to see in column d , dates from jan , feb , may , june , july etc ( no mar and april pls ) in column e , corr values of ibm in column f , corr values of nasdaq this can be done using if statement ....but i want to do it using a macro.. the other prob is that my data length is not constant, it changes and my stocks and indices change.....so i may have 1000 rows tomorrow and only 50 rows the next day ... how do i get this ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I rearrange data label sequence | Charts and Charting in Excel | |||
Adding a sequence to filtered data | Excel Discussion (Misc queries) | |||
Consolidation Worksheet Data Sequence. | Excel Worksheet Functions | |||
Expanding sequence of data | Excel Discussion (Misc queries) | |||
How can I sort data in sequence by odd/even numbers | Excel Worksheet Functions |