I dont know if this is possible but I have a large dataset with many employees. Each employee has repeating entries which identify any effective changes to their record. What I am interested in is to identify any FTE changes that happened to the first available record before 03/26/2023 to the first available record after 03/26/2023. The date I am referring to is the effective date.
There are two sheets contained in this file:
1. Desired Ouptut: basically what I want the formula to show me which are the instances of the changes before 03/26 and after 03/26
2. This is the actual data to filter.
This may be an impossible one, not sure or maybe I am over thinking it.