List starters and leavers on separate sheet

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

    Hi everyone,


    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.

    Hi Roy,


    Autofilter won't work as I need this data as part of a report. I just did not include all the rest of the data here as it is not related to my problem. I need a physical listing of starters and leavers between other data, that I pull from other sheets into one summary sheet.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login