User Profile
tlangfordindk
Copper Contributor
Joined Aug 16, 2022
User Widgets
Recent Discussions
Re: Creating a membership list
Thanks mtarler I've defined the data (B2:G7) as a table called Department_members and used the function below. However, the data it's returning (circled in the screenshot) sin't what I'm expecting. Any further advice? =FILTER(Department_members, Department_members[Dept 1]="x", "none")
