Advanced FILTER scenarios – Introduction

Modern Excel Reporting with FILTER Advanced FILTER scenarios Advanced FILTER scenarios - Introduction

Summary

In this section we’re working through a range of advanced techniques.

The methods include:

  • Combining tables (input stacking and lookup tables)
  • Displaying all records if no filter criteria provided
  • Handling text (partial text match, pattern matching with RegEx)
  • Using lists
  • Using slicers

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