FILTER()

Description

Returns a filtered version of the source range, returning only rows or columns which meet the specified conditions.

How To Use in Sheets

FILTER(range, condition1, [condition2])

External Links

Google Sheets Filter Function - 8 actionable examples

Learn how to use the powerful Google Sheets Filter function in your data analysis to filter your data quickly.

Google Docs Help

15Better Sheets Tutorials

Add A Timestamp to Task Lists (without Now Formula)
Advanced

2

FREE

How to Make a Marketplace in a Google Sheet
Intermediate
Creating A Dark Mode Theme | Announcing Dark Habits
IntermediateMost Popular
Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.
Better Domain Portfolio Template
Intermediate

5

FREE

Secure Your Sheets by BetterSheets.co
Beginner
Deep Inside Dark Habits Google Script
Add Pics to Marketplace in a Google Sheet
Beginner
Quadrant to List and List to Quadrant
Intermediate
Create a Public Sheet and Private Sheet: Using ImportRange()
Intermediate
Stick around after the 1st portion of the video for bonus content.
Create a PR Agency From Scratch
Go from nothing to a working PR agency. Capture sites, and Send email via script
Tagging Titles, Create a Comma Separated List of Tags
Intermediate
Create categories
Organize Anything! - Build a Kanban Board / Trello Board
Advanced
Organize leads, life tasks, chores, assignments, anything into a kanban or trello board.
Announcing Sell Daily and How I Built Sell Daily
Beginner

14

FREE

This Seems Like Automation
4 formulas that make your sheets feel automated. Start with user-started actions, and get automated data flowing in other parts of your sheet.
Create a Many to Many Database