We also want to exclude any empty cells from our results.
This can be translated literally as “return values from the named rangedatawhere values indataare not empty”.
This array is returned to the INDEX function as itsarrayargument.
The result is returned as thestartargument inside SEQUENCE.
We supply -1 forstepto step backwards fromstart.
This ensures that values are returned in the same order they appear in the source data.
The output from FILTER is dynamic.
If source data or criteria change, FILTER will return a new set of results.
The array can be one dimensional, or two-dimensional, determined byrowsandcolumnsarguments.
you’re able to use INDEX to retrieve individual values, or entire rows and columns.
The MATCH function is often used together with INDEX to provide row and column numbers….
