Equivalent of 'FILTER' function
I am looking for a solution to the below issue:
We have a Field Employees Sheet Master that has all of our employees listed from across 16 territories. We also need a seperate Field Employees Sheet per each territory that would populate new rows in the corresponding Territorial Sheet once new employees are added to the Master Sheet.
In Google Sheet's I would simply resolve this with the FILTER function, however, there is no equivalent in SS. Report Builder would not work in this case as well, since I need to add additional rows to the Territorial Sheets that are not a part of the Master Sheet.
For easier reference, I am attaching a picture of an example 'Master Sheet'
and Territorial Sheet for Territory B
Do you have any suggestions on how to resolve this?
Help Article Resources
Check out the Formula Handbook template!