Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have 3 time series on a excel worksheed (EurUsd, Euribor and Dow). Each time series has two columns: Values and Date. This is daily data. The problem is that for one I have 800 values, for other 820 and for the other 810. This is normal. In some days a market can be closed while the other is open. Is it possible to select only the values where all the markets are open? Basically I need to create 4 columns: Date, EurUsd Value, Euribor Value and Dow Value Only for the dates where all markets are open, so an intersection by date. I need to do this only once. Thanks, Miguel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Second Most Common Value | Excel Discussion (Misc queries) | |||
Combining two ranges based on common a common value | Excel Discussion (Misc queries) | |||
Most and least common | Excel Discussion (Misc queries) | |||
Common footer but not common margins please -(Page 1 of 2) etc | Excel Discussion (Misc queries) | |||
common dialog box | Excel Programming |