Hello-
I am attempting to create an architecture where employees are auto-populated based on role.
I have a sheet with the entire orgs employee list that contains names, employee numbers, and titles
The working sheet is attempting to pull in all people of each job title. Each row is a job title (same title with multiple people in these roles). I want each row to return an index collect from the collection range that has not already been collected in the previous rows. what sort of criterion script can I write to make this happen or are their work arounds.
Thanks,
John