{"id":3180,"date":"2021-03-29T16:50:00","date_gmt":"2021-03-29T23:50:00","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=3180"},"modified":"2021-03-30T08:48:22","modified_gmt":"2021-03-30T15:48:22","slug":"how-to-use-filter-function-in-excel","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=3180","title":{"rendered":"How to Use FILTER function in Excel"},"content":{"rendered":"\n<p>Filtering is a common everyday action for most Excel users.&nbsp; Whether using AutoFilter or a Table, it is a convenient way to view a subset of data quickly.&nbsp; Until the FILTER function came to Excel, there was no easy way to achieve this with formulas.&nbsp; When Microsoft announced the changes to Excel\u2019s&nbsp;calculation engine, they also introduced a host of new functions.&nbsp; One of those new functions is FILTER, which returns all the cells from a range that meet specific criteria. At the time of writing, the FILTER function is only available to those on a Microsoft 365 subscription.&nbsp; It will not be available in Excel 2019 or earlier versions.<\/p>\n\n\n\n<p><strong>Download the example file<\/strong><\/p>\n\n\n\n<p>I recommend you download the example file for this post.&nbsp; Then you\u2019ll be able to work along with examples and see the solution in action, plus the file will be useful for future reference.<\/p>\n\n\n\n<p><a href=\"https:\/\/exceloffthegrid.com\/download\/10052\/\" target=\"_blank\" rel=\"noreferrer noopener\"><\/a><br>Download the file:&nbsp;<a href=\"https:\/\/exceloffthegrid.com\/download\/10052\/\" target=\"_blank\" rel=\"noreferrer noopener\">0035 FILTER function in Excel.zip<\/a><\/p>\n\n\n\n<p><strong>Watch the video:<\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/23wnQNpFZho\" target=\"_blank\" rel=\"noreferrer noopener\">Watch the video on YouTube<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Arguments of the FILTER function<\/h2>\n\n\n\n<p>Before we look at the arguments required for the FILTER function, let\u2019s look at a basic example to appreciate what it does.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/exceloffthegrid.com\/wp-content\/uploads\/2020\/07\/FILTER-Function-Basic-Usage.gif\" alt=\"FILTER Function Basic Usage\" class=\"wp-image-10009\"\/><\/figure>\n\n\n\n<p>Here the FILTER function returns all the values in cells B3-B10 where the number of characters is greater than 15.&nbsp; Not a scenario that many of us will need, but it demonstrates the power of the new FILTER function.<\/p>\n\n\n\n<p>FILTER has three arguments:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=FILTER(array, include, [if_empty])<\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>array:<\/strong>&nbsp;The range of cells, or array of values to filter.<\/li><li><strong>include:<\/strong>&nbsp;An array of TRUE\/FALSE results, where the TRUE values will be retained in the filter.<\/li><li><strong>[if_empty]:<\/strong>&nbsp;The value to display if no rows are returned.<\/li><\/ul>\n\n\n\n<p><strong>Generate accurate VBA code in seconds with AutoMacro<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/www.automateexcel.com\/vba-code-generator\/?utm_source=200287236\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" src=\"https:\/\/exceloffthegrid.com\/wp-content\/uploads\/2019\/11\/AutoMacroExample.gif\" alt=\"AutoMacroExample\" class=\"wp-image-9260\"\/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Examples of using the FILTER function<\/h2>\n\n\n\n<p>The following examples illustrate how to use the FILTER function.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Example 1 \u2013 FILTER returns an array of rows and columns<\/h3>\n\n\n\n<p>In this example, cell F3 contains a single formula, but this formula returns an array of values into the neighboring rows and columns.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/exceloffthegrid.com\/wp-content\/uploads\/2020\/07\/FILTER-Function-retuns-array-of-rows-and-columns.png?ezimgfmt=rs:800x333\/rscb2\/ng:webp\/ngcb2\" alt=\"FILTER Function retuns array of rows and columns\" class=\"wp-image-10010\"\/><\/figure>\n\n\n\n<p>The formula in cell F3 is:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=FILTER(B3:D10,C3:C10&gt;100)<\/pre>\n\n\n\n<p>This single formula is returning 2 rows and 3 columns of data where the values in C3-C10 are higher than 100.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Example 2 \u2013 #CALC! error caused by the FILTER function<\/h3>\n\n\n\n<p>The screenshot below displays what happens when the result of the FILTER function has zero results \u2013 we get the new #CALC! error.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/exceloffthegrid.com\/wp-content\/uploads\/2020\/07\/FILTER-CALC-Error.png?ezimgfmt=rs:800x339\/rscb2\/ng:webp\/ngcb2\" alt=\"FILTER #CALC! Error\" class=\"wp-image-10012\"\/><\/figure>\n\n\n\n<p>The formula in cell F3 is:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=FILTER(B3:D10,C3:C10&gt;200)<\/pre>\n\n\n\n<p>As no rows meet the criteria of Invoice Value being higher than 200), the FILTER cannot return a value, so the #CALC! error is displayed.<\/p>\n\n\n\n<p>Thankfully, Microsoft has given us the&nbsp;<em>if_empty<\/em>&nbsp;argument, which displays a message if there are no rows returned.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/exceloffthegrid.com\/wp-content\/uploads\/2020\/07\/FILTER-Function-with-if_empty-argument.png?ezimgfmt=rs:800x335\/rscb2\/ng:webp\/ngcb2\" alt=\"FILTER Function with if_empty argument\" class=\"wp-image-10011\"\/><\/figure>\n\n\n\n<p>The formula in cell F3 is:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=FILTER(B3:D10,C3:C10&gt;200,\"No Results\")<\/pre>\n\n\n\n<p>In the screenshot above, \u201c<em>No Results\u201d<\/em>&nbsp;displays instead of the #CALC! error.<\/p>\n\n\n\n<p>If we wanted to display a result in each column, we could include a constant array within the&nbsp;<em>if_empty<\/em>&nbsp;argument.&nbsp; The following would show&nbsp;<em>n\/a<\/em>&nbsp;in the Invoice Value and Days Due columns.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=FILTER(B3:D10,C3:C10&gt;200,{\"No Results\",\"n\/a\",\"n\/a\"})<\/pre>\n\n\n\n<p>This formula would result in the following:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/exceloffthegrid.com\/wp-content\/uploads\/2020\/07\/FILTER-Function-no-results-multiple-if_empty-values.png?ezimgfmt=rs:800x333\/rscb2\/ng:webp\/ngcb2\" alt=\"nction no results, multiple if_empty values\" class=\"wp-image-10013\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Example 3 \u2013 FILTER expands automatically when linked to a table<\/h3>\n\n\n\n<p>This example shows how the FILTER function responds when linked to an Excel table.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/exceloffthegrid.com\/wp-content\/uploads\/2020\/07\/FILTER-expands-automatically-with-table.gif\" alt=\"FILTER expands automatically with table\" class=\"wp-image-10014\"\/><\/figure>\n\n\n\n<p>New records added to the table which meet the criteria are automatically added to the spill range of the function.&nbsp; Amazing stuff!https:\/\/be4aa64affb7f0c0054ae308f78a0cbd.safeframe.googlesyndication.com\/safeframe\/1-0-38\/html\/container.html<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Example 4 \u2013 Using FILTER with multiple criteria.<\/h3>\n\n\n\n<p>Example 4 shows how to apply FILTER with multiple criteria.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/exceloffthegrid.com\/wp-content\/uploads\/2020\/07\/FILTER-with-multiple-AND-conditions.png?ezimgfmt=rs:800x338\/rscb2\/ng:webp\/ngcb2\" alt=\"FILTER with multiple AND conditions\" class=\"wp-image-10015\"\/><\/figure>\n\n\n\n<p>The formula in cell F3 is:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=FILTER(B3:D10,(C3:C10&gt;50)*(D3:D10&gt;30))<\/pre>\n\n\n\n<p>For anybody who has used the SUMPRODUCT function, this method of applying multiple conditions will be familiar.&nbsp; Multiplication creates AND logic (i.e., all the criteria must be TRUE).&nbsp; The example above shows where the Invoice Value is greater than 50&nbsp;<strong>and<\/strong>&nbsp;the Days Due is greater than 30.<\/p>\n\n\n\n<p>Addition creates OR logic (i.e., any individual condition can be TRUE).<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/exceloffthegrid.com\/wp-content\/uploads\/2020\/07\/FILTER-with-multiple-OR-conditions.png?ezimgfmt=rs:800x323\/rscb2\/ng:webp\/ngcb2\" alt=\"FILTER with multiple OR conditions\" class=\"wp-image-10016\"\/><\/figure>\n\n\n\n<p>The formula in cell G3 is:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=FILTER(B3:D10,(C3:C10&gt;50)+(D3:D10&gt;30))<\/pre>\n\n\n\n<p>The example above shows where the Invoice Value is greater than 50&nbsp;<strong>or<\/strong>&nbsp;the Days Due is greater than 30.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Example 5 \u2013 Using FILTER for dependent dynamic drop-down lists<\/h3>\n\n\n\n<p>Drop-down lists are a data validation technique.&nbsp; Dependent drop-down lists are an advanced technique where the lists change depending on the result of another cell.&nbsp; For example, if the first drop-down list displays country names, the second drop-down list should only display cities that exist in that country.&nbsp; There are currently very tedious methods to achieve this effect, but the new FILTER makes this super easy.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/exceloffthegrid.com\/wp-content\/uploads\/2020\/07\/FILTER-Dependent-drop-down-lists.gif\" alt=\"FILTER - Dependent drop-down lists\" class=\"wp-image-10018\"\/><\/figure>\n\n\n\n<p>The formula in cell H3 is:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=UNIQUE(B3:B10)<\/pre>\n\n\n\n<p>The&nbsp;UNIQUE&nbsp;function creates a unique list to populate the drop-down in cell F4.<\/p>\n\n\n\n<p>The formula in cell I3 is:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=FILTER(C3:C10,B3:B10=F4)<\/pre>\n\n\n\n<p>Depending on the value in cell F4, the values returned by the FILTER function change.&nbsp; The second drop-down in cell F6 changes dynamically based on the value in Cell F4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Example 6 \u2013 Using FILTER with other functions<\/h3>\n\n\n\n<p>In this final example, FILTER is nested inside the SORT function.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/exceloffthegrid.com\/wp-content\/uploads\/2020\/07\/FILTER-and-SORT-together.png?ezimgfmt=rs:800x323\/rscb2\/ng:webp\/ngcb2\" alt=\"FILTER and SORT together\" class=\"wp-image-10019\"\/><\/figure>\n\n\n\n<p>The formula in cell F3 is:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=SORT(FILTER(B3:D10,D3:D10&lt;=30))<\/pre>\n\n\n\n<p>First, the FILTER function returns the cells based on the Days Due being less than or equal to 30.&nbsp; The SORT function then puts the Customers into ascending alphabetical order.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Filtering is a common everyday action for most Excel users.&nbsp; Whether using AutoFilter or a Table, it is a convenient way to view a subset of data quickly.&nbsp; Until the FILTER function came to Excel, there was no easy way to achieve this with formulas.&nbsp; When Microsoft announced the changes to Excel\u2019s&nbsp;calculation engine, they also <a class=\"read-more\" href=\"https:\/\/SUMMALAI.COM\/?p=3180\">Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,18],"tags":[661],"class_list":["post-3180","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-office","tag-filter-in-excel"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"Filtering is a common everyday action for most Excel users. Whether using AutoFilter or a Table, it is a convenient way to view a subset of data quickly. Until the FILTER function came to Excel, there was no easy way to achieve this with formulas. When Microsoft announced the changes to Excel\u2019s calculation engine, they also\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Summa Lai\"\/>\n\t<meta name=\"keywords\" content=\"filter in excel,microsoft family,microsoft office\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/SUMMALAI.COM\/?p=3180\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3180#article\",\"name\":\"How to Use FILTER function in Excel | Summa Lai\",\"headline\":\"How to Use FILTER function in Excel\",\"author\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?author=2#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/exceloffthegrid.com\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/FILTER-Function-Basic-Usage.gif\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3180\\\/#articleImage\"},\"datePublished\":\"2021-03-29T16:50:00-07:00\",\"dateModified\":\"2021-03-30T08:48:22-07:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3180#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3180#webpage\"},\"articleSection\":\"Microsoft Family, Microsoft Office, FILTER in Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3180#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/SUMMALAI.COM\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=10#listItem\",\"name\":\"Microsoft Family\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=10#listItem\",\"position\":2,\"name\":\"Microsoft Family\",\"item\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=10\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=18#listItem\",\"name\":\"Microsoft Office\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=18#listItem\",\"position\":3,\"name\":\"Microsoft Office\",\"item\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=18\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3180#listItem\",\"name\":\"How to Use FILTER function in Excel\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=10#listItem\",\"name\":\"Microsoft Family\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3180#listItem\",\"position\":4,\"name\":\"How to Use FILTER function in Excel\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=18#listItem\",\"name\":\"Microsoft Office\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/#person\",\"name\":\"sladmin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3180#personImage\",\"url\":\"https:\\\/\\\/SUMMALAI.COM\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Summa_Logo-150x150.png\",\"width\":96,\"height\":96,\"caption\":\"sladmin\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?author=2#author\",\"url\":\"https:\\\/\\\/SUMMALAI.COM\\\/?author=2\",\"name\":\"Summa Lai\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3180#authorImage\",\"url\":\"https:\\\/\\\/SUMMALAI.COM\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Summa_Logo-150x150.png\",\"width\":96,\"height\":96,\"caption\":\"Summa Lai\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3180#webpage\",\"url\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3180\",\"name\":\"How to Use FILTER function in Excel | Summa Lai\",\"description\":\"Filtering is a common everyday action for most Excel users. Whether using AutoFilter or a Table, it is a convenient way to view a subset of data quickly. Until the FILTER function came to Excel, there was no easy way to achieve this with formulas. When Microsoft announced the changes to Excel\\u2019s calculation engine, they also\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3180#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?author=2#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?author=2#author\"},\"datePublished\":\"2021-03-29T16:50:00-07:00\",\"dateModified\":\"2021-03-30T08:48:22-07:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/#website\",\"url\":\"https:\\\/\\\/SUMMALAI.COM\\\/\",\"name\":\"Summa Lai\",\"description\":\"Never Stop Learning, Building a Little Wiki...\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"How to Use FILTER function in Excel | Summa Lai","description":"Filtering is a common everyday action for most Excel users. Whether using AutoFilter or a Table, it is a convenient way to view a subset of data quickly. Until the FILTER function came to Excel, there was no easy way to achieve this with formulas. When Microsoft announced the changes to Excel\u2019s calculation engine, they also","canonical_url":"https:\/\/SUMMALAI.COM\/?p=3180","robots":"max-image-preview:large","keywords":"filter in excel,microsoft family,microsoft office","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/SUMMALAI.COM\/?p=3180#article","name":"How to Use FILTER function in Excel | Summa Lai","headline":"How to Use FILTER function in Excel","author":{"@id":"https:\/\/SUMMALAI.COM\/?author=2#author"},"publisher":{"@id":"https:\/\/SUMMALAI.COM\/#person"},"image":{"@type":"ImageObject","url":"https:\/\/exceloffthegrid.com\/wp-content\/uploads\/2020\/07\/FILTER-Function-Basic-Usage.gif","@id":"https:\/\/SUMMALAI.COM\/?p=3180\/#articleImage"},"datePublished":"2021-03-29T16:50:00-07:00","dateModified":"2021-03-30T08:48:22-07:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/SUMMALAI.COM\/?p=3180#webpage"},"isPartOf":{"@id":"https:\/\/SUMMALAI.COM\/?p=3180#webpage"},"articleSection":"Microsoft Family, Microsoft Office, FILTER in Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/SUMMALAI.COM\/?p=3180#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM#listItem","position":1,"name":"Home","item":"https:\/\/SUMMALAI.COM","nextItem":{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?cat=10#listItem","name":"Microsoft Family"}},{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?cat=10#listItem","position":2,"name":"Microsoft Family","item":"https:\/\/SUMMALAI.COM\/?cat=10","nextItem":{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?cat=18#listItem","name":"Microsoft Office"},"previousItem":{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?cat=18#listItem","position":3,"name":"Microsoft Office","item":"https:\/\/SUMMALAI.COM\/?cat=18","nextItem":{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?p=3180#listItem","name":"How to Use FILTER function in Excel"},"previousItem":{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?cat=10#listItem","name":"Microsoft Family"}},{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?p=3180#listItem","position":4,"name":"How to Use FILTER function in Excel","previousItem":{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?cat=18#listItem","name":"Microsoft Office"}}]},{"@type":"Person","@id":"https:\/\/SUMMALAI.COM\/#person","name":"sladmin","image":{"@type":"ImageObject","@id":"https:\/\/SUMMALAI.COM\/?p=3180#personImage","url":"https:\/\/SUMMALAI.COM\/wp-content\/uploads\/2020\/05\/Summa_Logo-150x150.png","width":96,"height":96,"caption":"sladmin"}},{"@type":"Person","@id":"https:\/\/SUMMALAI.COM\/?author=2#author","url":"https:\/\/SUMMALAI.COM\/?author=2","name":"Summa Lai","image":{"@type":"ImageObject","@id":"https:\/\/SUMMALAI.COM\/?p=3180#authorImage","url":"https:\/\/SUMMALAI.COM\/wp-content\/uploads\/2020\/05\/Summa_Logo-150x150.png","width":96,"height":96,"caption":"Summa Lai"}},{"@type":"WebPage","@id":"https:\/\/SUMMALAI.COM\/?p=3180#webpage","url":"https:\/\/SUMMALAI.COM\/?p=3180","name":"How to Use FILTER function in Excel | Summa Lai","description":"Filtering is a common everyday action for most Excel users. Whether using AutoFilter or a Table, it is a convenient way to view a subset of data quickly. Until the FILTER function came to Excel, there was no easy way to achieve this with formulas. When Microsoft announced the changes to Excel\u2019s calculation engine, they also","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/SUMMALAI.COM\/#website"},"breadcrumb":{"@id":"https:\/\/SUMMALAI.COM\/?p=3180#breadcrumblist"},"author":{"@id":"https:\/\/SUMMALAI.COM\/?author=2#author"},"creator":{"@id":"https:\/\/SUMMALAI.COM\/?author=2#author"},"datePublished":"2021-03-29T16:50:00-07:00","dateModified":"2021-03-30T08:48:22-07:00"},{"@type":"WebSite","@id":"https:\/\/SUMMALAI.COM\/#website","url":"https:\/\/SUMMALAI.COM\/","name":"Summa Lai","description":"Never Stop Learning, Building a Little Wiki...","inLanguage":"en-US","publisher":{"@id":"https:\/\/SUMMALAI.COM\/#person"}}]}},"aioseo_meta_data":{"post_id":"3180","title":null,"description":null,"keywords":[],"keyphrases":{"focus":[],"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":[],"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":{"id":"#aioseo-article-65a0c4895b967","slug":"article","graphName":"Article","label":"Article","properties":{"type":"BlogPosting","name":"#post_title","headline":"#post_title","description":"#post_excerpt","image":"","keywords":"","author":{"name":"#author_name","url":"#author_url"},"dates":{"include":true,"datePublished":"","dateModified":""}}},"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":"{\"article\":{\"articleType\":\"BlogPosting\"},\"course\":{\"name\":\"\",\"description\":\"\",\"provider\":\"\"},\"faq\":{\"pages\":[]},\"product\":{\"reviews\":[]},\"recipe\":{\"ingredients\":[],\"instructions\":[],\"keywords\":[]},\"software\":{\"reviews\":[],\"operatingSystems\":[]},\"webPage\":{\"webPageType\":\"WebPage\"}}","pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":{"businessInfo":{"name":"","urls":{"website":"","aboutPage":"","contactPage":""},"address":{"line1":"","line2":"","zip":"","city":"","state":"","country":""},"contact":{"email":"","phone":"","fax":""},"ids":{"vatID":"","taxID":"","chamberID":""},"payment":{"priceIndication":"","currenciesAccepted":"","methodsAccepted":""},"areaServed":""},"openingHours":{"show":false,"closedLabel":"","open24h":false,"open24hLabel":"","open247":false,"use24hFormat":false,"twoSets":false,"timezone":"","hours":[]}},"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2021-03-29 23:46:50","updated":"2024-01-12 04:48:09","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/SUMMALAI.COM\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/SUMMALAI.COM\/?cat=10\" title=\"Microsoft Family\">Microsoft Family<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/SUMMALAI.COM\/?cat=18\" title=\"Microsoft Office\">Microsoft Office<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tHow to Use FILTER function in Excel\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/SUMMALAI.COM"},{"label":"Microsoft Family","link":"https:\/\/SUMMALAI.COM\/?cat=10"},{"label":"Microsoft Office","link":"https:\/\/SUMMALAI.COM\/?cat=18"},{"label":"How to Use FILTER function in Excel","link":"https:\/\/SUMMALAI.COM\/?p=3180"}],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3180","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3180"}],"version-history":[{"count":2,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3180\/revisions"}],"predecessor-version":[{"id":3182,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3180\/revisions\/3182"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3180"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3180"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}