Excel Staff Rota

  • 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! [ATTACH]n1218443[/ATTACH]

Participate now!

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