This is a continuation of questions I have for a the data set I have in a post that the gracious members have helped me solve already.
Lets say my data was formatted as a table with a starting date of August 11th, and my very last line item actually ended on August 14th (ie row 52 was start date: August 13th, 2018 5:55pm to End Date: August 14th 6:23PM). Id like to create a list of unique dates from the columns Table1[Start Date YYYY-MM-DD] and Table1[End Date YYYY-MM-DD]. I solved it originally using an array index match looking strictly at my start date, however I realized that if I have an end date that isn't also a start date it won't add to the list, also my function gets a little funny because it will repeat dates for some reason on this example file...
From researching this website and google I have found lots of results for a predefined column range so you can always look for say $A$2:$A$52, list could have as many as 500 entries or as few as 1 which is why I like formatting it as a table. However, it will always only ever be limited to the two columns titled Start Date and End Date.
Bookmarks