I have this sheet where I want to do simple project planning and resource booking
The columns 6-17 show week numbers and each main objective within a project has a start week and end week - no actual dates needed in this case
So I set the start/end week numbers and based on that either X or Y is set into the cell, I'll use that for conditional formatting later to display a "Gantt" like view
Now the problem I am facing is with the resources further down the page.
How do I find the objective Jane is booked for that has the highest week number?
Resources can be part of several objectives and what I want to display in the bottom is, when will Jane be available again for new projects?