HI all,
I have a spreadsheet that has very large table data and currently i am summarsing the data using SUMIFS or SUMPRODUCT and converting into hourly timeseries data and so it takes a while to calculate. The exact data there are a lot of rows
I had a go at converting them into VBA using both WorksheetFunction and Evaluate SUMIF but it took just as long. I have been researching using Dictionary in VBA which seems very fast however the examples i have seen don't have similar conditions to mine. It just populates a summary using exact conditions, my conditions are greater than or equal to and include dates/times.
I have attached a simple example of the data table and the format of the results using a simple sumproduct formula. The Summary output criteria are already populated and so it would just be the Output ("Quantity") i'd need in Column M populating.
Hopefully someone can help.
Thanks
Bookmarks