How to Filter in Multiple Columns in Google Sheets

If you are looking for tips and tricks for working on Google Sheets, then you have definitely come to the right website! For the topic of this article, I am going to talk about how you can filter in multiple columns in Google Sheets.

Now, I am going to use a set of data where I will have information based on the sales revenue of a business earned from selling certain services. These services were provided throughout various branches of the same company and this too will be included in my data. To present this information, I will need to use multiple columns, obviously.

set of example data in the sheet

As you can see from the example I am using, there are a total of three columns and I have information in each of them.

Now, let me show you the steps to filtering multiple columns in Google Sheets. Don’t worry, once you finish reading this article, you will see that filtering multiple columns in Google Sheets is so easy.

Filtering Multiple Columns in Google Sheets: In 4 Steps

1. Suppose, I want to filter out the rows in column A, which have branch A, or, the service that was provided was a facial.

Firstly, I will need to select cell A1 (just click on the cell to select it). Then, find the Data option from the menu at the top of the spreadsheet and click on it. A drop-down menu will appear and from all the features, I will select the feature that says “Create a Filter”.

2. Once you have selected this feature, filter icons will appear on the top row in each of the columns. They will allow you to filter through the data.

Create a Filter

Afterward, I will click on the filter icon which is beside the word “Branch” to see a display of options in which I can do the filtration of the data.

From the options, go straight to the second last one that says “Filter by condition” and click on it.

Filter by condition

This will open up a new, second drop-down menu. I will ignore all of the options displayed here and go straight to the last option which says “Custom formula is”.

3. In the third step, I will give my input for the “Custom formula is”. This will be the following:

=OR(A:A = “A” ,B:B = “Facial”)

Input the custom formula

4. After giving this input, if I click on “Okay”, I will get all the rows which have either the branch “A” in column A, or, the service “facial” in column B.

Get The Result of Filtering Multiple Columns in Google Sheets by Custom Formula

You can check out another similar topic from TeqTog, which is on sorting by multiple columns in Google Sheets

Filtering Multiple Columns: and

In the instance I just shared with you, the filtering option was to either see columns that had the branch “A”, or, columns which had the service “facial”.

However, if I should want to see all of the columns which have the branch “A” and the service “facial”; then there is a formula input for that too. In this case, I just need to modify the formula given in the “Custom formula is” dialogue box. I simply need to change the beginning of the formula (OR) to (AND) and I will get the relevant results just as same.

Filtering Multiple Columns: and

Click on “OK” just like in the first example.

Results after changing the formula-replace OR with AND in condition

Now my spreadsheet is displaying all of the columns which have the branch “A” and the service “facial” inclusively.

Closing Thoughts

And there you!

I hope you found my article on how to filter multiple columns in Google Sheets helpful.

You can Also Read:

How to Change Row Height in Google Sheets

How to Compare Two Dates in Google Sheets

Floor Function in Google Sheets

How to Turn Scientific Notation On and Off in Google Sheets

How to Count Unique Values in Google Sheets (2 Easy Methods)

Was this article helpful?
YesNo


Related More Articles

Leave a Comment