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

 Building the Output Table

Our original data resides on a large worksheet, so we need to create a new worksheet for the output table. Create a new sheet in your workbook and build the fields for the filter criteria and the output table headers.

Output Table Headers

In this example, the 45 is the minimum Combined MPG value that is acceptable for our list of vehicles.