Forum Discussion
Filling in a Table with Intermittent Dates
I am trying to fill in a table with large amounts of data. The table I am filling has an unbroken list of dates through the year, as I am tracking a building's energy usage throughout the year. Howev...
Based on what I see in the existing sheets, it's clear that you're not a novice with Excel. So let me just ask whether you're familiar with the newest Dynamic Array functions? Notably FILTER, which might well allow you to do the filtering of the data from your source file, bringing the desired data into your various School summary sheets.
That function does require the newest version of Excel, so if you don't currently have it, it would be worth while getting it.
Here's a YouTube video that serves as a good introduction to FILTER, but also some of the associated concepts and functions. https://www.youtube.com/watch?v=9I9DtFOVPIg