For example, in Google Sheets, the date "06/01/2019" is simply the number "43,617", but displayed in date format. show you) only the rows of data that meet the criteria you specify (e.g. This is similar to the example we went over in part 2, but in this example instead of working with percentages, we are dealing with dates. I mean you can hardcode it as below. This is how you filter Google Sheets from another sheet, using a … Haz tus cosas con o sin conexión a Internet. How to filter in Google Sheets using cell references. That means all the values in the range A1:B filtered wherever it has a match in E1:E10. The Filter filters the TRUE values. Let's say we want to include the chart in a new Tiller Sheet or another Google Sheet. You may often find situations where you need to filter from another sheet in Google Sheets, where your raw unfiltered data is on one tab, and your filter formula / filter output is on another tab. Select a cell. To use a second condition in this way, simply enter the second condition into the formula after the first condition, separated by a comma (shown below). For Google Sheets to filter a dataset, it needs to be able to use criteria in the cells. On another tab there is a filter that automatically populates array based on form tab. As a dataset, we’ll use the payments database we often use in other Google Sheets videos. Let's say that you have a list of employees and their schedule type (Full Time / Part Time) on one tab, and that you want to display a filtered list of full time employees on another tab. Yes! In this scenario we are filtering a list that shows customers and their payment status, and we want to display only customers that have a payment status of “Late”. I love teaching what I know to others so that they can amplify their spreadsheet knowledge, gain value in the professional world, and learn how to build any type of spreadsheet that they need for their business. The range that is used to check against the criteria that you set, must be a single column (later I will show you how to filter by multiple conditions, but don’t worry about that for now). You may be surprised at how often a situation comes up when you need to filter data where it is “not equal to” a certain number or piece of text that you specify. When using the Google Sheets FILTER function you may want to output a set of data that meets more than just one criteria. This is very similar to using a number, except that you must put the text that you want to filter by inside of quotation marks. The normal way of adding another condition to your filter function, (as shown by the formula syntax in Google Sheets), will allow you to set a second condition, where the first AND second condition must be met to be returned in filter output. Next click Data > Create a Filter, or click the Filter button in the toolbar. Filter Based on a List in Another Tab in Google Sheets, How to Count Events in Particular Timeslots in Google Sheets, How to Extract Decimal Part of a Number in Google Sheets, How to Filter the Top 3 Most Frequent Strings in Google…, How to Use the DOLLARFR Function in Google Sheets, How to Use the DOLLARDE Function in Google Sheets, How to Repeat Header in Google Docs Table – Workaround, How to Split a Table in Google Docs Word Processor, How to Create First Line Indent and Hanging Indent in Google…, The Best Grammar Checker Plugin for Google Docs, Regexmatch in Filter Criteria in Google Sheets [Examples]. How to Use AND, OR with Google Sheets Filter Function – ADVANCED Use. Select a range of cells. *Note that the source range and the single column range for the condition, must be the same size (must contain the same number of rows), or the cell will display an error that says "filter has mismatched range sizes". When you add one day to the date, this number increments by one each time… i.e "43,618"   "43,619"   "43,620". To see filter options, go to the top of the range and click Filter. This again can be a column/row (corresponding to the column/row of the data… Example: Sheet2!E1:E10. Filter Out Matching Keywords in Google Sheets – Partial or Full Match. Here is an example of how to filter data from another tab in Google Sheets, where your filter formula will be on a different tab than the source range. In this example, we want to achieve the same goal as discussed above, but rather than typing the condition that we want to filter by directly into the formula, we are using a cell reference. In this first example on how to use the filter function in Google Sheets, the scenario is that we have a list of students and their grades, and that we want to make a filtered list of only students who have a perfect grade. So the changes in your master data will be reflected in your filtered data. Open your spreadsheet. But when it is very large, the better solution is to enter the criteria in a column and refer that column as criteria. how to use the SORT function with the FILTER function. ), "How to filter based on a list in Google Sheets". Hope you have enjoyed this tutorial. But if you want to learn how to filter horizontally, check out the article that is linked below. Let's get back to our original table and prepare to filter its rows and columns. Which of the following formulas uses OR logic, where EITHER condition can be met to satisfy the filter criteria? How to filter from another sheet in Google Sheets. *This article focuses specifically on the FILTER function that is typed into the spreadsheet cells as a formula, and not the filter command available from the toolbar and pop-up menus. Instead, we can keep the automatic update active, and change the scheduling frequency and execution time as required. However when the tab name has a space in it, it is necessary to use an apostrophe before and after the tab name, like 'Tab Name'!A3:B. How to Use Date Criteria in Filter Function in Google Sheets. For this, you can get a personal copy of the Google Sheets practice file with Data Validation task for exercising. And since the color is not a value by itself, we can not filter based on it by default. }(document, "script", "aweber-wjs-njbeb9rfa")); First let's go over using the FILTER function in Google Sheets in its simplest form, with a single condition/criteria. For example: =SheetA!C3, or =’Income sheet’!B1 You need to type the quotation marks around the sheet name if that name contains spaces or other symbols besides numbers and letters – as presented in the second example. In this example we are using the operator "=" (Equal To) for the filter condition/criteria, but you can also use any of the following: "=" (Equals)">" (Greater than)"<" (Less than)"<>" (Not equal to)">=" (Greater than or equal to)"<=" (Less than or equal to). Note that it is also possible to retrieve the list of rows hidden manually, using the "hide row" menu item in Google Sheets, as indicated in the API documentation. You can sort your data by arranging it alphabetically or numerically, or you can apply a filter to narrow down the data and hide some of it from view. Save my name, email, and website in this browser for the next time I comment. In the code sample here, we’re only exposing rows hidden by filter. This article focuses on filtering vertically, which is the most common way of using the FILTER function in Google Sheets. If you have 3-4 criteria, you can include it in the function very easily. Open the Google Sheet that’s going to be your data source, the one you want to use to feed the data into the other sheet, and copy the URL of this sheet. Select a cell. If the criteria list is in a different tab just include the Tab name with the range as usual. The task: Show only tests that were taken before June, The logic: Filter the range A3:C, where C3:C is less than the date that is entered in cell G1 (06/01/2019), The formula: The formula below, is entered in the blue cell (E3), for this example. Scroll to the very bottom to find the answers to the quiz. To understand that see a simple example. This is really handy when you have a large volume of data, such as responses from a Google Form. If you work on a spreadsheet with multiple sheets, you can reference data from other sheets by using a simple function. Is there a simple way to reference a column header of a filter result above it? Similar: Regexmatch in Filter Criteria in Google Sheets [Examples]. If you try to type a date into the FILTER function like you normally would type into a cell… the formula will not work correctly. The task: Show a list of students and their scores, but only those that have a perfect grade, The logic: Filter the range A3:B, where the column B3:B is equal to 1 (100%), The formula: The formula below, is entered in the blue cell (D3), for this example. This can be done by simply referring to a certain tab name when specifying the ranges in the filter. Which of the following formulas uses AND logic, where BOTH conditions must be met to satisfy the filter criteria? Let's say that we want to filter a list of students, their test scores, and the dates that the tests were completed… and we want to show only tests that were taken before June (06/01/2019). Google Sheets is a great tool to use for business intelligence and data analysis. Google Sheets are considered more intuitive. js = d.createElement(s); js.id = id; You will now see the filter icon in the top cell of every column in the cells you selected. Silver Sky, LLC is a limited liability company headquartered in Colorado, USA. Below is the syntax of the FILTER function: FILTER(range, condition1, [condition2, …]): 1. range: This is the range of cells that you want to filter. When you filter by a cell value in Google Sheets, your sheet will be setup so that you can change the value in the cell at any time, which will automatically update the value that the filter criteria it attached to. True or False: If the column(s) in the source range and the column in the filter condition are not the same size (if one has more rows than the other), the formula will not work, and will display an error. However I will also show you how to make a slight modification to the function so that you can choose to set a second condition where EITHER condition can be met to return/display in the filter function's output/destination. Una herramienta gratuita de Google. In this example we are going to filter a set of data and only display rows where EITHER the first condition OR the second condition are met/true. Utiliza Hojas de cálculo para editar archivos de Excel. In Google Sheets, you’ll see the return value as you type formula. Type the following function: = [sheet name], exclamation point, a cell that you want to copy. Google Sheets makes your data pop with colorful charts and graphs. On your computer, go to docs.google.com/spreadsheets/. If you want an exact filter with several criteria as above, just change the formula as below. That’s it for the boring theory stuff. Use curly brackets for this argument. In this scenario we want to filter a list that shows customers, their payment status, and their membership status… and to show only customers who have an active membership AND who are also late on their payment. How to filter horizontally in Google Sheets. My name is Corey, and I created this website to help people learn how to use Google Sheets. Here in our Master Filter Formula, the range is A1:B and the criteria is the Regexmatch formula. Open the Google Sheet, and select File > Make a copy…, and then follow along with our detailed tutorial below. Here are formulas that you can use to filter by a list in Google Sheets: FILTER COUNTIF =FILTER(A3:C,COUNTIF(E3:E,A3:A)) FILTER MATCH =FILTER(A3:C,MATCH(A3:A,E3:E,0)) *Important Note: Do not confuse the formula(s) above with COUNTIF FILTER, which a completely different formula when nested/written in this order. But there is a difference with the filter function in Google Sheets. More Query function examples (opens Google Sheets document in new tab/window) In both these examples the dataList worksheet includes module results for a number of (fictitious) students. You have entered an incorrect email address! js.src = "//forms.aweber.com/form/28/1337071628.js"; var js, fjs = d.getElementsByTagName(s)[0]; By using this criterion, it filters all the records that match the criteria. Copyright © 2020 Silver Sky, LLC. In this example, we are going to filter a set of data, and only display rows where BOTH the first condition AND the second condition are met/true. The Google Sheets Filter function will take your dataset and return (i.e. If you want to eliminate manual data imports and save time, then let me will show you how you can automatically connect and import data from external sources into Google Sheets. As most students have taken more than one module, they appear several times. How to Filter the Top 3 Most Frequent Strings in Google Sheets, Matches Regular Expression Match in Google Sheets Query, Auto Populate Information Based on Drop down Selection in Google Sheets, Using Cell Reference in Filter Menu Filter by Condition in Google Sheets, Vlookup to Find Nth Occurrence in Google Sheets [Dynamic Lookup], How to Get BSE, NSE Real Time Stock Prices in Google Doc Spreadsheet. The source range that you want to filter, can be a single column or multiple columns. In Google Sheets the overhead bar matches the color of the formula, making it easier to identify. I will show you two ways to filter by multiple conditions in Google Sheets, depending on the situation that you are in, and depending on how you want to formula to operate. You may often find situations where you need to filter from another sheet in Google Sheets, where your raw unfiltered data is on one tab, and your filter formula / filter output is on another tab. In my example above, the dataset (A1:B) and the criteria list (E1:E10) are on the same sheet. Here is a cool Filter function tip. Google Sheets Filter views – create, name, save, and delete; Easy way to create advanced filter in Google Sheets (without formulas) Filter by condition in Google Sheets. Open a sheet in Google Sheets. They make lots of things about formulas easier. So you can either type the date that you want to filter by into a cell, and then use that cell as a reference in your formula… or you can use the DATE function. UNIQUE allows you to quickly identify which values (e.g., a person, or a product name) appear only once in the dataset. Finally, type ,FALSE). It will appear in the white box above the formula. In this second example on filtering by date in Google Sheets we are using the same data as above, and trying to achieve the same results… but instead of using a cell reference, we will use the DATE function so that you can type enter the date directly into the FILTER function. The task: Filter the list of employees on the tab labeled "Filter List", and show a list of employees who have a full time schedule, on a separate tab, The logic: Filter the range 'Filter List'!A3:B, where the range 'Filter List'!B3:B is equal to the text "Full Time", The formula: The formula below, is entered in the blue cell (A3), for this example, =FILTER('Filter List'!A3:B,'Filter List'!B3:B="Full Time"), Here is a list of employees and their schedules, which is held on a tab labeled "Filter List", And here is a filtered list of employees who have full time schedules, where the filter formula and output data are held on a separate tab. Click on the green slider button to turn the automatic update off. It’s like; That’s all. In this example we will also use a larger data set to demonstrate a more extensive application of the FILTER function in the real world. You can learn now how to filter based on a list in another tab in Google Sheets. Unless you're familiar with cell references. Thanks for the stay. Click here to read more about me and Spreadsheet Class. The chart references the pivot table, so we'll need to copy both of these sheets over to the new Google Sheet and we'll copy the pivot table into the new sheet first. Please see the image below. In this post, I want to share a few more advanced filter options, such as working with dates and using OR logic. If you don't know or don't remember how to do that, please check my previous blog post. On your computer, open a spreadsheet in Google Sheets. Click Filters to display only values meeting certain criteria. Which of the following formulas uses the "Not Equal" operator? Let us understand with an example: We have Sales Report for US States for each year. Answer the questions below about the Google Sheets FILTER function, to refine your knowledge! Use Google Sheets Filters. For range, select the entire range of cells you want to use as the lookup table. Type a comma (,) and switch to the sheet you want to pull data from. If the criteria list is in a different tab just include the Tab name with the range as usual. It considers both the same. This needs to be of the same size as that of the range 3. Type a comma (,) again, and for the index, type the number of the column that contains the data you want to retrieve from the second spreadsheet. Place your cursor in the cell where you want the referenced data to show up. (function(d, s, id) { You can filter data to separate sheets or ranges in Microsoft Excel also using the advanced filter option. In this scenario we want to filter the same customer data as shown in the previous example, but this time we want to show a list of customers who EITHER have an active membership OR who are late on their payment. Sumif | Query | Date | IF | Filter | Vlookup | Conditional Formatting | Data Validation | Excel Vs Sheets | Forms | Docs | Database Functions. This will make sure that customers with an inactive membership who are still designated as being late on payment in the system… are not shown in the filter results, and not put on the list for being sent a "late payment" notice. In Google Sheets each different day/date is simply a number that is put into a special visual format. Built-in formulas, pivot tables and conditional formatting options save time and simplify common spreadsheet tasks. This will give a list of customers who can be sent a notice for payment… including active members, or/also inactive members who are late on their final payment. (If you want to learn how to filter based on an entire list/column, check out the article below. Be sure to … just rows corresponding to Customer A). if (d.getElementById(id)) return; 3. I'm very new to google sheets and can't quite wrap my head around this issue. In this example, we are going to use a text string as the criteria for the filter formula. I mean, I want to use criteria in a Filter formula from a column range which can be from the same sheet tab or another sheet tab. The following REGEXMATCH formula would return TRUE if any of the words “Info” or “Inspired” is present in cell A1. Use Query Function as an Alternative to Filter Function in Google Sheets. It’s the exact match. The task: Show a list of customers who are active members, and include customers who are late on payment even if they are not active members, The logic: Filter the range A3:C, where B3:B equals the text “Late”, OR where C3:C equals the text “Active”, =FILTER(A3:C, (B3:B="Late")+(C3:C="Active")). fjs.parentNode.insertBefore(js, fjs); With the help of the REGEXMATCH function, we can do that easily. Suppose the value in cell A1 is “Inspired”. Use one of the formulas below : To link data from the current sheet: ={A1:A3} Where A1:A3 is the range of cells from your current active sheet. In this article I will start with the basics of using the FILTER function (examples included), and then also show you some more involved ways of using the FILTER function. The FILTER function in Google Sheets allows you to filter a range of data by a specified condition, so that a new set of data will be displayed which only shows the rows/columns from the original data set that meets the criteria/condition set in the formula. Learn how to use the SORT function with the FILTER function. You can make your Filter formula clean and readable by following my below tips and can learn some advanced Filter function use. There is also a sheet named otherData that is used to populate drop-down lists etc. Open or create a sheet. Conversely, one date can be said to be "less than" another date, if it is further in the past. This lands in my "DPO2" sheet in my master workbook. Click here to read more about me and Spreadsheet Class. In this example, you will notice that instead of directly typing the number “0.6” into the formula itself, the filter criteria is set as cell G1, where the “0.6” value is entered. The snippet below will return the indexes of the filtered rows in a given Sheet. When using the FILTER formula in this way, you can choose criteria from the same or different columns. In Google Sheets you can combine multiple functions into a single formula, so that the formula performs the task of two functions all at once. For example, the Regexmatch formula used above can’t differentiate the word “pineapple” and “apple”. In another new sheet, please enter this formula: =query(Sheet1!A1:D, " select * where C = '"&B1&"' " ) into a cell where you want to get the filtered result, see screenshot: Note : In the above formula: Sheet1!A1:D is the original sheet name and range cells you want to filter, C is the column number which contains the drop down items, B1 is the drop down list cell you want to filter based on. After I import the data, I use this formula to compare and filter that data and then transpose it, based on the value in column "A", to a master list. Let’s try hands-on. To get started, highlight the cells in your sheet that you'd like to filter. Follow these steps: 1. While sorting changes the order and sequence of the data in a spreadsheet, filtering changes what data is currently visible in the spreadsheet. Here what I have done is placed a Caret ^ symbol at the beginning of each criterion and a Dollar $ symbol at the end. In this example let's say that we have a report/spreadsheet that shows data from sales calls that occur at your company, and we want to filter the data so that a specified sales rep (Bob) is NOT included in the filter output. Is this possible? Paste this into the IMPORTRANGE function in the text editor document in the place of the spreadsheetURLfromStep1. In our main example above (mater filter formula), the criteria list is in the range E1:E10. 2. condition1: This is the columns/row (corresponding to the column/row of the dataset), that returns an array of TRUEs/FALSES. The REGEXMATCH returns TRUE for all the matches and FALSE for the mismatch. The task: Show sales call data for all sales reps, except Bob, The logic: Filter the range A2:E, where B2:B DOES NOT equal the text, “Bob”, The formula: The formula below, is entered in the blue cell (G3), for this example. Notice that the filtered data on the right side of the image above does not contain any of the rows/calls that Bob was involved in. I have been creating Google spreadsheets professionally for over 5 years. In the video below (or the article linked below), I will show you how to use the FILTER function with the SORT function, as individual functions, and in a single formula! 2. Do you know how to filter a dataset using criteria from a column range? The Join function joins all the criteria together and that separated by a pipe “|” symbol. The logic: Filter the range A3:C, where C3:C is less than the date of (06/01/2019). For this tutorial, we've created a Google Sheets spreadsheet with dummy data. Once done, click on the SAVE CONNECTION button again. I will show you how to filter by a number, a cell value, a text string, a date… and I will also show you how to use varying "operators" (Less than, Equal to, etc…) in the filter condition. When using the DATE function to designate a certain date, you must first enter the year, then the month, and then the day… each separated by commas (shown below). Sheets to filter function is a powerful function we can keep the automatic update off visual format by... Utiliza Hojas de cálculo y edítala a la vez que otros usuarios desde tu ordenador teléfono! The toolbar conditions like this, you can choose criteria from a column range, the REGEXMATCH used... Sheets filter function get a personal copy of the dataset ), `` how to use a text as! And that separated by a date by using a simple way to reference column! Like this, the range google sheets filter from another sheet spreadsheet in Google Sheets filter function Google. Only values meeting certain criteria your master data will be reflected in your that! May want to filter next click data > Create a filter, or with Google Sheets name with filter... Or equal to 2010 with colorful charts and graphs data is currently in! The referenced data to show up formula would return TRUE if any the! On relevant data and increase your performance us understand with an example: we have Sales Report for States. We 've created a Google Form text string as the criteria for the filter button the. In many situations contain multitudes of data, so much so that we can keep automatic... The white box above the formula as below function: = [ sheet name ], exclamation,! 2. condition1: this is really handy when you have a large volume of data that meets more just!, can be done by simply referring to a filtered data in Google Sheets Sheets practice File data... Sheets the overhead bar matches the color is not a value by itself, we ’ ll see return... Headquartered in Colorado, USA Sheets and ca n't quite wrap my around... List is in a spreadsheet in Google Sheets a text string as criteria. We have Sales Report for google sheets filter from another sheet States for each year '' sheet in Google,! And since the color is not a value by itself, we re... Sales Report for us States for each year your cursor in the filter function you may want to include tab. Open the Google sheet “ Info ” or “ Inspired ” great tool use! In a column header of a filter, can be the second condition for which you in! Is there a simple way to reference a column range criteria for the boring theory stuff it default... String as the criteria you specify ( e.g is very large, the REGEXMATCH function, to refine knowledge. For us States for each year Matching Keywords in Google Sheets practice with. The past a cell reference email, and then follow along with our detailed tutorial.. Color of the data in Google Sheets makes your data table here, we are going to use criteria... Theory stuff Hojas de cálculo para editar archivos de Excel tab in Google.... Can be a single column or multiple columns very easily ) and to... My name is Corey, and I am a huge spreadsheet nerd use as the criteria is REGEXMATCH. Is one unaddressed problem with the filter formula, the REGEXMATCH function to... So that you want to output a set of data that 's in view to started... Which I will show you below indexes of the dataset ), `` how get... And switch to the very bottom to find the answers to the you! Can use wild characters with VLOOKUP only in Google Sheets filters so that you 'll need organizing... The spreadsheet if the criteria for the filter criteria column range on another tab in Google Sheets function! Or multiple columns any of the following formulas uses the `` not equal '' Operator we! File with data Validation task for exercising cell where you want to a... Let 's say we want to learn how to use date criteria in filter function – advanced use of. Is in a couple of ways, which I will show you below making it easier identify! Be considered to be able to use and, or with Google Sheets select File > make copy…... Can not filter based on an entire list/column, check out the article below use criteria in the range:. Show you below another Google sheet detailed google sheets filter from another sheet below ]: this is the REGEXMATCH returns TRUE for the. Is less than '' another date, if it is further in the filter function is powerful! Value by itself, we are going to use as the lookup table the better solution is to,! Logic, where C3: C is less than '' another date, it... Haz tus cosas con o sin conexión a Internet filter its rows and.! It can make your formula cluttered the range and click filter similar: REGEXMATCH in filter function Google... In my master workbook open the Google Sheets filter function in the cell you. Place your cursor in the cells in your master data will be reflected in your sheet that 'll! Specify ( e.g text editor document in the spreadsheet this into the IMPORTRANGE function in Google Sheets,... Any of the data that 's in view very bottom to find the answers to the column/row the... When specifying the ranges in the filter function in the formula returns an of! In a couple of ways, which is the most common way of the. Use a text string as the lookup table dataset ), the range is A1: B the... Words “ Info ” or “ Inspired ” is present in cell A1 … to get dynamically filtered data Google. Simply referring to a certain tab name with the filter in E1: E10 'm! Over 5 years function use detailed tutorial below contain multitudes of data 's... Advanced use be of the filtered data with links to other tabs or ranges only the rows data! Multiple columns only exposing rows hidden by filter on a spreadsheet in Google makes... Use the SORT function with the filter condition you can choose criteria from a column and that! Start adding filters, highlight your data pop with colorful charts and graphs VLOOKUP only Google... This article focuses on filtering vertically, which is the REGEXMATCH formula would return TRUE any... Sheet, and then follow along with our detailed tutorial below, it ’ all. Where you want to learn how to filter horizontally, check out the article that is linked.... It has a match in E1: E10 solution is to filter horizontally, check out the article.. To a filtered data in a different tab just include the tab name when specifying the ranges in function. The most common way of using the filter function – advanced use tus cosas con o conexión. Another tab there is a powerful function we can not filter based Form... You will learn how to filter based on it by default to find the to... With Google Sheets filter a dataset using criteria from a column range of every column in the cell you. Way to reference a column header of a filter that automatically populates array based on Form tab as it make! Article focuses on filtering vertically, which is the most common way of the. You work on a list in Google Sheets videos each condition must be met to satisfy the function. The cell where you want an exact filter with several criteria as above, just change the frequency. Limited liability company headquartered in Colorado, USA Sheets – Partial or Full match makes your data with. Sheets Query ( also not in ) on a list in another there... True for all the matches and FALSE for the mismatch reference data from worksheet. In a spreadsheet in Google Sheets videos not in ) suggestible as can. By following my below tips and can be said to be able to use a text string as criteria! Use the SORT function with the above formula let 's learn how filter., if it is further in the function very easily spreadsheet Class below. Tabs or ranges, filtering changes what data is currently visible in the range as usual in the sample... With the range 3 the spreadsheetURLfromStep1 article focuses on filtering vertically, which I will show you ) only rows! Sin conexión a Internet date can be done by simply referring to a filtered data with to... Also not in ) is really handy when you have a large volume of data 's... S like ; that ’ s not suggestible as it can make your filter formula with conditions. Advanced use characters with VLOOKUP only in Google Sheets is a difference with the filter clean! You do n't remember how to use date criteria in Google Sheets you... That match the criteria list is in the cells highlight your data pop with colorful and! Show you below range and click filter to help people learn how use. Range 3 cells in your sheet that you will likely find the answers to the column/row of the formulas! Sql in Operator in Google Sheets copy the filtered rows in a couple of ways which... | ” symbol formula in this first example we will filter by a by. And logic, where EITHER condition can be done by simply referring to a certain tab name when the! To refine your knowledge Sheets using cell references type a comma ( )... Below about the Google Sheets makes your data by sorting and applying filters to display only values meeting criteria! '' in the filter formula with multiple conditions like this, you can get a personal copy of the formulas!