You can filter using menu buttons and create filter buttons in Google Sheets, but sometimes it’s valuable to setup a FILTER formula. One such instance is shown in the GIF below: when you have a Sheet that contains data about many students across many grades or classes. Using a filter formula, you can create a tab for each class or grade. You can also create tabs for certain criteria (like lower scores that require follow-up).
=FILTER(range, condition1, [condition2, …])
Note from the formula above, that you can actually identify multiple criteria (such as Mr. Kotter’s students who scored below a 75%).
