Extract a List of Values Filtered by Criteria with Sub-Arrays

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.

Formula Drag Down

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.

Output Table Example

If we change the criteria from 45 to 40, more vehicles qualify, so the list grows!

Output Table Expanded

Using these guidelines, you should be able to create a dynamically updated filtered data table based on the criteria of your choice. Happy filtering!