[HELP!!!] Importing time series data with different dates.

%3CLINGO-SUB%20id%3D%22lingo-sub-1733915%22%20slang%3D%22en-US%22%3E%5BHELP!!!%5D%20Importing%20time%20series%20data%20with%20different%20dates.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1733915%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20create%20a%20table%20which%20depends%20on%20the%20date%20and%20the%20time%20series.%20For%20example%2C%20I%20want%20to%20get%20the%20Date%20and%20Values%20for%20Series%201%2C%20then%20I%20want%20the%20dates%20to%20start%20on%20the%20May-15%20and%20if%20I%20need%20to%20get%20the%20values%20for%20series%202%2C%20I%20would%20want%20the%20date%20to%20start%20on%20Oct-17.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1733915%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1734200%22%20slang%3D%22en-US%22%3ERe%3A%20%5BHELP!!!%5D%20Importing%20time%20series%20data%20with%20different%20dates.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1734200%22%20slang%3D%22en-US%22%3EWill%20you%20be%20so%20kind%20as%20to%20give%20a%20little%20bit%20detailed%20explanation%20regarding%20your%20request%2C%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F666974%22%20target%3D%22_blank%22%3E%40NewbieTTM%3C%2FA%3E%3F%3CBR%20%2F%3EThanks%20in%20advance%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1734201%22%20slang%3D%22en-US%22%3ERe%3A%20%5BHELP!!!%5D%20Importing%20time%20series%20data%20with%20different%20dates.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1734201%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F666974%22%20target%3D%22_blank%22%3E%40NewbieTTM%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20you%20desiring%2Fdescribing%20a%20single%20table%20with%20those%20different%20parameters%20for%20Series%201%20and%20Series%202%3F%20Or%20are%20those%20two%20examples%20for%20two%20tables%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20any%20event%2C%20if%20you%20have%20access%20to%20the%20FILTER%20function--it's%20available%20on%20the%20newest%20versions%20of%20Excel--then%20that%20should%20be%20able%20to%20extract%20the%20data%20you%20want%20from%20this%20starting%20raw%20data.%20I've%20attached%20an%20example%20for%20your%20first%20example.%20Here's%20the%20formula.%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DFILTER(FundData3%5B%5BDate%5D%3A%5BSeries%201%5D%5D%2CFundData3%5BDate%5D%26gt%3B%3D'Series%201'!C3%2C%22No%20data%20meet%20criterion%22)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENote%2C%20this%20is%20a%20Dynamic%20Array%20function%2C%20so%20is%20entered%20in%20only%20one%20cell%20with%20the%20results%20%22spilling%22%20into%20however%20many%20rows%20are%20needed.%20You%20do%20not%20need%20to%20copy%20the%20formula%20down.%20For%20more%20info%20on%20how%20FILTER%20and%20some%20other%20associated%20Dynamic%20Array%20functions%20work%2C%20I%20suggest%20viewing%20this%20YouTube%20video.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I want to create a table which depends on the date and the time series. For example, I want to get the Date and Values for Series 1, then I want the dates to start on the May-15 and if I need to get the values for series 2, I would want the date to start on Oct-17. 

5 Replies
Will you be so kind as to give a little bit detailed explanation regarding your request, @NewbieTTM?
Thanks in advance

@NewbieTTM 

 

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.

https://www.youtube.com/watch?v=9I9DtFOVPIg

Learn everything about our brand-new Dynamic Arrays and how you can use them to build advanced spreadsheets. Arrays (CSE) have long been present in Excel, bu...

@Ilgar_Zarbaliyev Apologies I didn't explain exactly what I wanted. Say in a new tab, I create a drop down list to select the Series, I want to pull in Series 1, I would want the first value in the date column to be March 2015. If I select Series 2, I need the first value in the date column to be October 2017. So basically, I need the to pull a time series without any gaps at the start. Hope this helps.

Thanks @mathetes, I will try this on my latest version of excel.

@NewbieTTM 

 

You're welcome.

 

Feel free to come back with questions and further clarification if that doesn't do what you wish.