I built a set of functions demonstrating dynamic filtering and sorting using Excel and PyXLL. The functions determine whether a value is within a numeric interval (closed, open, or any combination).
A video illustrates the performance.
One million filters