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!