This Scribe shows you how to apply a filter to a dataset. You can use filters to find specific data in your dataset based on certain criteria.

Click here the filter icon in any of the column headers to open up the filter

You can sort and filter based on a number of criteria including alphabetical, absolute value, color, conditions, etc.

Sort A → Z
Sort Z → A
Sort by color
►
Filter by color
►
Filter by condition
Filter by values
Select all-Clear
Andrew
Bob
Caroline
Erica
Jessie
Joe
CancelOK

Google Sheets is a powerful online tool to help you do quantitative analysis. Learn how to use formulas to manipulate and analyze datasets, such as Google Sheets' COUNTIF and SUMIF functions, among many others.

How to apply filters in a Google sheet