Excel Dynamic Arrays Filter Function
To generate the list of unique dates that occur AFTER the selected "from" date, we will use the FILTER function. To understand the FILTER function, the syntax is as follows: FILTER(array, include, [if_empty]) array – are the cells containing the data. If the cells being examined are part of a "spilled" array, select only the first cell in the array followed with a "#" symbol (ex ...