I am trying to build a dynamic filter that will filter a data range based on an list of employee #’s AND the pay period they started and stopped working on a project (I feel like this should be easy, but I can’t figure it out!). The dataset I’m pulling from has data for the whole company for the year. I only need a subset of the employees (easy enough to filter) but then I want to filter that based on when they started with the group or when they left the group. I need the formula to be dynamic to be able to handle additions to the employee list, which could be up to 80 employees. Its almost like I need to filter an array by an array, if that’s possible?!