staff rotas

  • Hi


    I have a staff rotas that are a bit of a mess but I am not allowed to change them.


    So I have linked them and bought them into one workbook to format and make function in a more useable way.


    To that end I have been asked to show a list of staff availability.


    I hope the attachment explains it.


    I have tried using Index/Match/Aggregate but I am stumped!

    Staff.zip

  • My guess is there is a rather complicated series of formulas that would do this for you. However, it would be much more easily accomplished with a data model.


    Is Power Pivot an option for you?


    Grits ain't groceries

    Eggs ain't poultry

    And the truth value of certainty is null.

Participate now!

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