Posts by golepori


    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!