# Multiple Conditions in Same Column Filtering in Google Sheets

0
60

Earlier I’ve introduced you how to apply AND, OR in FILTER function in Google Sheets. In this post we can learn how to apply multiple conditions in same column filtering in Google Sheets.

• How to use AND Logic in Filter function in Google Sheets,
• How to use OR Logic in Filter function in Google Sheets,
• Use of Comparison Operators in Filter in Google Sheets, please check our below guide.

How to Use AND,OR with Google Sheets Filter Function

Let’s back to our specific topic, Multiple Conditions in Same Column Filtering in Google Sheets. I will try to explain this aspect with few different criteria examples. So here we begin.

## Ho Do I Use Multiple Conditions in Same Column Filtering in Google Sheets

We can follow a simple sample data as below:

Example 1 with Numeric Criteria:

#### FILTER Function with Multiple Numeric Conditions or Criteria in Same Column.

Here I want to filter column B for received qty 400 or 500. Here is the filter formula to use.

=filter(A2:D, (B2:B = 400) + (B2:B = 500))

Example 2 with Text Criteria:

#### How to Use FILTER Function with Multiple Text Criteria in Same Column.

Suppose you want to filter Column A for Apple or Mango, how to apply these multiple conditions in that same column? See the formula.

=filter(A2:D, (A2:A = “Apple”) + (A2:A = “Mango”))

Example 3 with Date Criteria:

#### Multiple Date Conditions in Same Column Filtering in Google Sheets.

Let us see how to filter same column for different dates.

=filter(A2:D,(D2:D = date(2017,11,22)) + (D2:D = date(2017,11,27)))

The above three conditions are the most commonly using criteria type in Google Sheets Filter Function.

## Conclusion

This way, you can use multiple conditions in same column filtering in Google Sheets. Hope to see you again with another awesome Google Doc spreadsheet tutorial. Enjoy!

SHARE

A technology enthusiast and addictive blogger who likes to travel and wish to mingle with different community of people from around the world.