Forum Discussion
Complex If/Then assistance
Situation: As with many offices we are operating under a half on/half off rotation and I am trying to build a spreadsheet that can show who is teleworking and who is not on a given week based on the...
Here's a solution for part of that, a drop down box that goes through a list of names and team assignments and, based on selection of team A or B, lists the names associated with that team.
This does use the functions FILTER and SORT, which are only available to those who have the newest version of Excel, so if it doesn't work for you, that would be why. Come back and let us know if that's the case, so another solution can be created.
I didn't incorporate dates and other features because it wasn't clear how exactly you were wanting that to operate. I was tackling only the basic problem of getting a drop down to select a team and have the members listed. The rest of that is refinement for which I'd ask a more complete description.