Forum Discussion
Solved
Creating a membership list
Hi all I'm trying to create a list of people who report to a number of Departments In the example above, this should output the following list It feels like there should be a quick ...
(EDIT: Picture shows wrong results but can't be replaced - sorry)
in I3 then copy right until M3:
=FILTER(Department_members[[Name]:[Name]], Department_members[Dept 1]="x", "none")
(EDIT: Picture shows wrong results but can't be replaced - sorry)
in I3 then copy right until M3:
=FILTER(Department_members[[Name]:[Name]], Department_members[Dept 1]="x", "none")
Amazing, that's exactly what I need!
Thanks for both of your help 👍🏻
Thanks for both of your help 👍🏻
tlangfordindk. Glad we could help - ALL credit mtarler & Thanks for providing feedback