The filter function enables you to display some information from a list based on specified selection criteria.
This simple FILTER formula returns the Names of the people from the list above that are in the team specified in B10, Red in this case.
This is an example of a formula that will “SPILL” down into the cells below, so even though the formula is only in one cell, the results of the formula take up two cells in this case, indicated by the blue box.