I would need your help again because I am stuck now. I have a list of employees with their start and end date. On a separate sheet, I want to list all leavers and starters for the next month, based on the company they work with. I have an INDEX formula (with SMALL), but this can only look for all starters and leavers, it cannot separate by company. How could I do that?
So when I select "NORTH" in cell C1, I want to see only the starters/leavers from company NORTH. If I select "SOUTH" in C1, then of course only the ones from company South.
I also tried the MATCH function with several criterias connected with *, but that did not work either. Anyone can help? File is attached.
Thanks so much for your assistance.