Detect that Not one of the functions call for complete references, because they only exist in a single mobile, and spill their results to neighboring cells. Thus, only particular rows are shown, when other rows which never satisfy the filter condition aren't shown.  Pick a tab solutio