I have a spreadsheet where I have imported a month electricity usage report for each month (Each Day is also broken down into 48 x 30 min periods) using Power Query and then created additional reports based on Day or Week or Month including rolling 7 day Average etc. The spreadsheet now takes several refresh clicks and over a minute for each refresh to complete. I decided to look at how I could reduce this and think about how I would do this if Power Query was not available. So hear is my question. I have the main imported table with all the raw data and want to extract all unique dates into a separate table however, all I seem to get is either the table will fill to the current length or I get #Spill Error. If I don't use a table, then something like the Unique Function will work as a dynamic array, or if I define the first and last Dates using MAX or Min Functions the the Sequence will also work as a Dynamic array. I would prefer to use tables as I like the way that formulas flow down. I would be grateful for any suggestions.