Forum Discussion
Index and Match
Added the formulae that I believe to give the outcome you are after in Sheet4 (file attached). Note that I changed the Week-headers to plain numbers. In the shaded area, I kept the intermediate steps that I took in building the formulae in the weekly schedule above it. Just my way of going through such a task, step-by-step, in order to create a bigger formula. I'm sure others will have a different approach and can come up with a more elegant solution.
At the same time, I have added a pivot table as it seems to achieve a similar and more flexible) result without complicated formulae.
In same assumptions as Riny_van_Eekelen I added Power Query variant.
Bu I agree with mathetes - formula is not linked with the sample and that's not clear what shall be the result - show only assigned activities or that could be unassigned in the list, show only weeks with assignments or all 52 weeks, and in general what to show.
