Input stacking

Modern Excel Reporting with FILTER Advanced FILTER scenarios Input stacking

Summary

This video looks at how to combine multiple tables into a single FILTER function.

Tab in example file: Stacking inputs

By using HSTACK and VSTACK we can combine multiple tables into a single array. These stacked arrays can then be used inside the arguments of the FILTER function.

Advanced FILTER scenarios

  1. Advanced FILTER scenarios - Introduction
  2. Input stacking
  3. Lookup tables
  4. Display all if blank
  5. Partial match
  6. RegEx
  7. Based on a list
  8. Using slicers