Posts by golepori

    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