I have a spreadsheet contains the different offices for our company.
I would like to extract, using a formula, all the members that work in that office.
If the Office was named Alcosta, for example, and their were 10 members I would like to show all the members belong to that office.
Then, in...