Finishing the Output Table
Now that we have built the sub-array formula, we can drag it across our output table headers and then down the sheet. We have to guess how many rows we need, since the list won’t go further than the number of rows we build even if there are more entries. I chose about 40 rows for the example.
Now you should be able to see the output of our sub-array formula. It lists only the items from our original table that meet the minimum MPG criteria.
If we change the criteria from 45 to 40, more vehicles qualify, so the list grows!
Using these guidelines, you should be able to create a dynamically updated filtered data table based on the criteria of your choice. Happy filtering!