Forum Discussion
[HELP!!!] Importing time series data with different dates.
Are you desiring/describing a single table with those different parameters for Series 1 and Series 2? Or are those two examples for two tables?
In any event, if you have access to the FILTER function--it's available on the newest versions of Excel--then that should be able to extract the data you want from this starting raw data. I've attached an example for your first example. Here's the formula.
=FILTER(FundData3[[Date]:[Series 1]],FundData3[Date]>='Series 1'!C3,"No data meet criterion")
Note, this is a Dynamic Array function, so is entered in only one cell with the results "spilling" into however many rows are needed. You do not need to copy the formula down. For more info on how FILTER and some other associated Dynamic Array functions work, I suggest viewing this YouTube video.
