FILTER Formula in Google Sheets

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%).

Filter Formula (Google Sheets) Animation

Published by

Jake Miller

Jake is a Google for Education Certified Trainer and is the Lead Technology Integration Specialist for Brady Middle School in Ohio's Orange City Schools. In the past he taught STEM, Science & Math in Stow-Munroe Falls, Ohio, where he was also a leader in the district's Technology Leadership Team and a co-advisor for the middle school's STEM Club. He has been an educator since 2003. His Bachelor's Degree is in middle-level education (math/science) from the University of Akron and his Master's Degree is in Instructional Technology from Kent State University. He has enjoyed providing more than 100 professional development opportunities at conferences and school districts across the state of Ohio. He is very involved in Twitter (@JakeMillerTech) and provides regular pointers for educators with his #GAFETip tweets.