Forum Discussion
Formula
FILTER does the job, although I used the actual entry in your column F rather than expecting it to search for the text BC in that column.
=FILTER(Overall!A8:O20,Overall!F8:F20="Brian (BC)")
I referenced rows through row 20, just to illustrate the point that it would filter a larger database. I wasn't able to copy your single row (I tried) to demonstrate that.
I do see that you have multiple people in the case of Toronto, and perhaps in others. I'd recommend either making this into two columns, one with the name, the other with the region OR just using a slightly more complicated FILTER criterion. The video I referenced above shows how to have multiple criteria and reference them with, in effect, AND or OR. In this case, to get each of the TORONTO folks into one sheet, you'd use the method that constitutes OR. It's tricky at the start, so use the video to educate yourself.
Here's the formula, which need only be entered in one cell. It spills to all columns and rows needed to satisfy the criteria. A more complete dummy workbook would have demonstrated that. I'd be happy to show how that would work, but you'll need to provide a more complete dummy database.
mathetes Does it only work for 1 filter at a time? When I put it for Midwest for example it shows spill under BC.
See attached
- You had entered something in column O and that interfered with the function's working. Once I deleted it, it worked. Whenever you see the SPILL# error, it's because something is blocking the full results. Have you looked at the YouTube video? I really do recommend it for a full explanation.