Google Sheets Filter on Two Columns: A Practical Guide

Yes. In Google Sheets, create a filter for your data, then apply a condition in each of the two column dropdowns; rows remain visible only when they meet both columns’ criteria. For a repeatable formula result, use FILTER with conditions for both columns.

What filtering two columns means

A filter narrows the rows shown in a table without deleting the rows that do not match. Filtering two columns means applying a rule to each column at the same time. For example, a sales list could show only records where Region is West and Amount is at least 100. A row must satisfy both rules to remain visible.

Filters work across records, not independently down each column. If the region in column B and the amount in column C belong to the same record on row 8, Sheets evaluates those values together. This is useful for narrowing a large list by combinations such as department and status, product and date, or city and order total.

One key distinction: filtering is not the same as sorting. Sorting changes row order; filtering hides rows that fail the conditions. You can sort and filter the same range, but sorting alone will not limit which records appear.

How the built-in filter combines criteria

In a standard Sheets filter, conditions set on different columns are combined as AND rules. If you filter Region to West and Amount to values greater than or equal to 100, a row must be in West and have an amount of at least 100. A matching value in just one column is not enough.

This matches the usual meaning of “filter on two columns”: find rows that pass both tests. You can also set more than two column conditions; Sheets applies them together in the same way. Within one column, selecting multiple values in the Filter by values list usually means show rows matching any of those selected values. That is an OR choice within that column, while criteria in separate columns still narrow the results together.

For example, selecting West and East in the Region value list, then setting Amount to at least 100, shows rows from either region provided their amount also passes the threshold. This distinction between OR within a column and AND across columns is a common source of confusion.

Apply a filter to two columns step by step

In Google Sheets in a web browser, first make sure the table has one header row and that the columns to be filtered belong to the same contiguous data range. Then:

Select a cell in the table, or select the complete range including its headers.
Choose Data > Create a filter. Filter icons appear in the header cells of the selected range.
Open the filter icon in the first column and choose values to keep, or select Filter by condition and choose a rule such as Text contains or Greater than.
Open the filter icon in the second column and set its rule in the same way.
Check the visible rows and adjust either dropdown if the result is too broad or too narrow.

Suppose column B is Region and column C is Amount. Choose West under Region, then use a numeric condition in Amount for values greater than or equal to 100. The result is the intersection of those conditions. To clear just one criterion, reopen its dropdown and clear its selections or remove its condition; to remove the filter controls, choose Data > Remove filter.

Include all relevant columns when creating the filter, not just the two columns containing the criteria. Otherwise, the displayed range may not behave like a complete table, and neighboring data may be left outside the filter. Keep a single, clear header row; blank rows or unrelated data within a range can also make it harder to identify the table Sheets should filter.

Choose values, conditions, or both

The filter dropdown offers different ways to describe what should remain visible. Filtering by values is convenient when a column contains a manageable list of categories, such as West, East, and Central. Filtering by condition is better for rules such as “text contains urgent,” “date is after,” or “number is greater than.” The available condition choices depend on the type of data and the column.

Use values for a short, known list of exact entries, such as two named regions.
Use a condition for thresholds, text searches, dates, or other rules that apply to many possible values.
Combine approaches when one column needs selected categories and another needs a threshold or condition.

For instance, you might select West and East in the Region list, then set Amount to greater than 100. That includes either chosen region, but only rows that also exceed the amount threshold. Be precise about boundaries: “greater than 100” excludes exactly 100, while “greater than or equal to 100” includes it.

Use a formula when you need a separate result

The built-in filter changes which rows are displayed in the source range. If you want a second, formula-driven list that updates as source data changes, use the Sheets FILTER function instead. Keep the output area clear so the returned rows have room to expand.

Assume headers are in A1:C1, data is in A2:C100, column B contains Region, and column C contains Amount. To return rows where Region is West and Amount is at least 100, enter this in an empty cell outside the source data:

=FILTER(A2:C100,(B2:B100="West")*(C2:C100>=100))

The multiplication combines the two TRUE/FALSE tests as AND: both must be true for a row to be returned. For example, a West row with an amount of 120 appears; a West row with 80 and an East row with 150 do not. The formula returns the matching rows from columns A through C, without changing the original table’s visibility.

For OR across two region values while still requiring the amount threshold, use the same assumed layout and enter:

=FILTER(A2:C100,((B2:B100="West")+(B2:B100="East")>0)*(C2:C100>=100))

The addition makes either region match sufficient; the comparison to zero turns that result into a TRUE/FALSE test. Multiplying by the amount test still requires the amount condition. In Sheets, FILTER returns #N/A if nothing matches, so check the criteria and source values if that appears. These combined-condition formulas also use a form compatible with current Excel dynamic-array formulas, though the steps above describe Google Sheets.

Use filter views for personal or saved views

A regular filter is useful when one person is working with a sheet and wants to narrow the shared data range. If several people need different filtered displays, a filter view is often a better fit: it lets a user apply a view without imposing the same filter settings on everyone else using the sheet. Filter views can also be named and reopened.

In Sheets on the web, choose Data > Filter views > Create new filter view, then set conditions in the relevant column dropdowns as you would with a regular filter. Use a descriptive name such as “West orders over 100” so the purpose is clear. Filter views are especially useful for recurring review tasks or when collaborators need different ways to inspect the same records.

A filter view is not a separate copy of the spreadsheet data. It changes the view of the shared records, so edits made to cells still affect the spreadsheet itself. Use a separate sheet or a formula-generated output if you specifically need a distinct result area rather than a saved way to view the original rows.

Common problems and how to fix them

The result is empty. Confirm that at least one row satisfies both conditions. Check spelling, extra spaces, number formats, and whether the threshold includes or excludes the boundary value.
Some rows do not filter with the table. Recreate the filter using the full contiguous range, including the relevant columns and headers. Look for blank rows that may split the data.
A number condition behaves like text. Values that look like numbers may have been imported as text. Check the cells’ contents and formatting, and convert the source values to numbers when appropriate.
The filter seems to include the wrong rows. Check whether you selected multiple values in a dropdown, or used “greater than” where you intended “greater than or equal to.” Remember that different column criteria are combined with AND.
The formula shows an error or cannot expand. In a FILTER formula, check that each condition range has the same number of rows as the returned range. Clear cells beneath or beside the formula if they block its output, and verify that the conditions actually match records.

It is also worth checking whether the source includes a header row and whether the filter range accidentally includes notes or totals beneath the table. A total row inside the filtered range may disappear when it fails the conditions, which can look like a calculation problem even though filtering is working as set.

Which method should you use?

Use a regular filter for quick, interactive analysis of the original table. Use a filter view when collaborators need separate saved views. Use FILTER when you want matching rows displayed elsewhere, for a report or a downstream calculation. A formula result is convenient because it updates with the source, but it requires space for its output and is less interactive than dropdown filters.

For a one-time question such as “Which West orders are at least 100?”, the built-in filter is usually the simplest choice. For a dashboard with a dedicated results section, a formula can be easier to reference. Neither approach deletes nonmatching records; if you plan to remove data permanently, make a copy first and distinguish deletion from filtering.

Frequently Asked Questions

Can I filter two columns at once in Google Sheets?
Yes. Create a filter for the table, then set a condition in each column’s dropdown. Sheets shows rows that satisfy both column conditions.

Does Google Sheets use AND or OR between columns?
Conditions in separate columns work as AND: a row must pass each one. Multiple selected values within one column can work as OR, so either selected value may qualify.

Can I filter one column by two values and another by a number?
Yes. Select both values in the first column’s Filter by values list, then set a numeric condition in the second column. Rows must match either selected value and pass the number condition.

Will filtering delete rows that do not match?
No. A filter hides nonmatching rows from the current view; the underlying data remains in the sheet. Removing the filter makes the rows visible again.

Why does FILTER show #N/A?
In Google Sheets, that usually means no rows met all supplied conditions. Check the criteria, source data, and boundary choices; also confirm the condition ranges align with the range being returned.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.