List starters and leavers on separate sheet

  • 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!