I have a spreadsheet that pulls in date from a table with date/time corresponding to a number. I need to be able to pull out all dates and times that are unique, sort them by smallest to largest.
Currently I am using
=INDEX(Table_ExternalData_1[SampleDateTime],MATCH(0,INDEX(COUNTIF($E$2:E3,Table_ExternalData_1[SampleDateTime]),0,0),0))
to extract from the External Data Table for unique values, but the values extract as they are found in the table. The makeup of the data is such that every 10-15 data points correspond to a unique tracked component, so the dates will never automatically be in the correct sequence.
The current attempt I am trying to make is to
1. import the data from an external data source.
2. extract all unique date and times.
3. sort the date/time by smallest to largest on separate sheet.
4. sort component values by date time into columns using Index/Match.
I am running into a problem getting 3 to work with a changing dataset. I think I am missing something simple, and I apologize if I am.
The test spreadsheet is attached to the post.
Thank you for the help.
Bookmarks