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.
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.
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.
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”)
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.
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.
Click on “OK” just like in the first example.
Now my spreadsheet is displaying all of the columns which have the branch “A” and the service “facial” inclusively.
And there you!
I hope you found my article on how to filter multiple columns in Google Sheets helpful.
You can Also Read: