Quick Navigation1Example Data2Choosing Criteria and Output Data3 Building the Output Table4Designing the Sub-Array Formula5Using the Sub-Array Formula6Breaking Down the Sub-Array Formula Syntax7Finishing the Output Table8Sub-Array Example File DownloadWhen you are working with large data sets, Excel’s built-in filters are a lifesaver, letting you get straight to the sub-set of data that you need. Sometimes, though, you … Continue reading Extract a List of Values Filtered by Criteria with Sub-Arrays