Auto creating a parent column from another sheet.
I am hoping to run some project information on how many people are working on a project and how many tasks do they have. Unfortunately I have many different projects with over 200 people listed in an assigned to columns and I want to have an auto way to pull the names of the assigned people to help me do some other Count if functions for number of tasks, duration of tasks, hours worked on tasks etc.
So I wanted to use the follow column to generate a way to only get each name listed one time in another sheet for data purposes so that I could do reports for each person.
So the people listed in those columns would only be listed once automatically in the new sheet pulling from that column.