[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
There are multiple ways of filtering data in Microsoft Excel, including the built-in column filters in Excel tables. However, this changes the original data by hiding rows. Using the FILTER function, you can reproduce a filtered version of the original data. This allows you and your team to work with different filtered versions of the data without affecting others or creating isolated copies of the data. You can also combine the FILTER function with others, such as SUM or AVERAGE, to operate directly on the filtered data. To add up values that meet a single condition, you can also use the SUMIF function in Excel<\/a>.<\/p>\n In this guide, you will learn how to use Microsoft Excel\u2019s FILTER function. First, you will review the syntax and learn how to match values by exact text, numerical values, and dates. Second, you will learn how to filter arrays by multiple conditions using FILTER with the OR (+) and AND (*) symbols. Finally, you have examples of how to use FILTER with functions like UNIQUE and SORT.<\/p>\n You will also learn about an alternative solution that allows you to transfer filtered data between Excel workbooks without having to write any formulas. With Sheetgo<\/a>, an AI-powered data automation platform, you can connect your files and choose the filters you want to apply with just a few clicks.<\/p>\n [\/et_pb_text][et_pb_text module_id=”filter-function-syntax” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Excel’s FILTER function has two required parameters and one optional parameter. It is available in Excel for Microsoft 365, Excel for the web, and Excel 2021 or later.<\/p>\n =FILTER(array,include,if_empty*)<\/p>\n<\/blockquote>\n The screenshots in this guide use a semicolon between arguments, which is the list separator in some regional settings. If your Excel uses commas, as in the syntax above, type a comma instead.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-use-filter-function-in-excel” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Using the FILTER function in Excel is easy: just select the array and the criteria you want to use to filter the values. Optionally, you can specify what the function should return if the filter finds nothing to return. Below, you have step-by-step instructions on how to filter by text, numerical value, and by date. In the next section, you will learn how to use it with multiple criteria or conditions and how to combine it with other functions.<\/p>\n Follow the steps below to get records matching an exact text value in one of the columns.<\/p>\n 1.<\/strong> In an empty cell, type the FILTER function and select the array you want to filter as the first parameter.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-filter-function-select-array.webp” alt=”Excel FILTER function \u2014 =FILTER(A2:H1001; typed in cell J2 next to the sales table” title_text=”=FILTER(A2:H1001; typed in cell J2 next to the sales table” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Add a semicolon followed by the condition. In this case, the text in column E must equal \u201cThirdProduct\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-filter-function-match-text.webp” alt=”Excel FILTER function \u2014 =FILTER(A2:H1001;E2:E1001=ThirdProduct) with the product column outlined” title_text=”=FILTER(A2:H1001;E2:E1001=ThirdProduct) with the product column outlined” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Close the parenthesis and press \u2018Enter\u2019 to see the results.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-filter-function-text-results.webp” alt=”Excel FILTER function \u2014 ThirdProduct records returned from cell J2″ title_text=”ThirdProduct records returned from cell J2″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n If you want to match values greater than or equal to a specific value, follow the steps below.<\/p>\n 1.<\/strong> Type the FILTER function and select the array.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-filter-function-number-array.webp” alt=”Filter function in Excel \u2014 =FILTER(A2:H1001 typed in cell J2 for a numeric filter” title_text=”=FILTER(A2:H1001 typed in cell J2 for a numeric filter” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Add a semicolon and the condition you want to use. In this case, I want records with $750 or more in the \u2018amount\u2019 column.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-filter-function-greater-than-or-equal.webp” alt=”Filter function in Excel \u2014 condition F2:F1001 greater than or equal to 750 on the amount column” title_text=”Condition F2:F1001 greater than or equal to 750 on the amount column” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Close the parenthesis and press \u2018Enter\u2019.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-filter-function-number-results.webp” alt=”Filter function in Excel \u2014 records with amounts of 750 or more returned from cell J2″ title_text=”Records with amounts of 750 or more returned from cell J2″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You can also combine the FILTER and DATE functions to filter by date.<\/p>\n 1.<\/strong> In an empty cell, type the FILTER function and select the array.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-filter-function-date-array.webp” alt=”Excel FILTER function \u2014 =FILTER(A2:H1001; typed in cell J2 for a date filter” title_text=”=FILTER(A2:H1001; typed in cell J2 for a date filter” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> After the semicolon, add the condition. In this example, records must be from before April 1st.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-filter-function-before-date.webp” alt=”Excel FILTER function \u2014 condition H2:H1001 before DATE(2022;4;1) with the date column outlined” title_text=”Condition H2:H1001 before DATE(2022;4;1) with the date column outlined” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Close the parenthesis and press \u2018Enter\u2019.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-filter-function-date-results.webp” alt=”Excel FILTER function \u2014 records dated before April 1, 2022 returned from cell J2″ title_text=”Records dated before April 1, 2022 returned from cell J2″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”use-the-excel-filter-function-with-multi” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The Excel FILTER function can also be used with multiple conditions. These can be OR conditions – where values can meet either of the conditions – or AND conditions – where values must meet both conditions.<\/p>\n Follow the steps below to return records where the \u2018product\u2019 column matches \u201cFirstProduct\u201d or \u201cThirdProduct\u201d.<\/p>\n 1.<\/strong> In an empty cell, type the FILTER function and select the cells with the array.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-filter-multiple-conditions-or-array.webp” alt=”Excel FILTER multiple conditions with OR \u2014 =FILTER(A2:H1001 typed in cell J2″ title_text=”=FILTER(A2:H1001 typed in cell J2″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Add the first condition between parentheses.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-filter-multiple-conditions-or-first.webp” alt=”Excel FILTER multiple conditions with OR \u2014 first condition (E2:E1001=FirstProduct) in parentheses” title_text=”First condition (E2:E1001=FirstProduct) in parentheses” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Add an OR symbol (+) followed by the second condition between parentheses.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-filter-multiple-conditions-or-second.webp” alt=”Excel FILTER multiple conditions with OR \u2014 plus sign joining the FirstProduct and ThirdProduct conditions” title_text=”Plus sign joining the FirstProduct and ThirdProduct conditions” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> Close the parentheses for FILTER and press \u2018Enter\u2019 to see the results.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-filter-multiple-conditions-or-results.webp” alt=”Excel FILTER multiple conditions with OR \u2014 FirstProduct and ThirdProduct records returned from cell J2″ title_text=”FirstProduct and ThirdProduct records returned from cell J2″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Follow the instructions below to use multiple criteria and ensure that the records match all of them.<\/p>\n 1.<\/strong> Type the FILTER function in an empty cell and select the array.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-filter-multiple-conditions-and-array.webp” alt=”Excel FILTER multiple conditions with AND \u2014 =FILTER(A2:H1001; typed in cell J2″ title_text=”=FILTER(A2:H1001; typed in cell J2″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Add a semicolon and type the first condition between parentheses. In this case, I want records for FirstProduct.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-filter-multiple-conditions-and-first.png” alt=”Excel FILTER multiple conditions with AND \u2014 first condition (E2:E1001=FirstProduct) after the array” title_text=”First condition (E2:E1001=FirstProduct) after the array” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Add an AND (*) symbol and type the second condition between parentheses. In this example, I want only records for Agent1.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-filter-multiple-conditions-and-second.png” alt=”Excel FILTER multiple conditions with AND \u2014 asterisk joining the product condition and (G2:G1001=Agent1)” title_text=”Asterisk joining the product condition and (G2:G1001=Agent1)” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> Close the parentheses and press \u2018Enter\u2019.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-filter-multiple-conditions-and-results.png” alt=”Excel FILTER multiple conditions with AND \u2014 FirstProduct records for Agent1 returned from cell J2″ title_text=”FirstProduct records for Agent1 returned from cell J2″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”use-filter-with-other-functions” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As mentioned above, the FILTER function can be combined with other built-in functions to manipulate the data after filtering. Below, you have examples using UNIQUE and SORT.<\/p>\n Follow the steps below to filter the results by the amount and get a list of unique customers. To clean up the source table itself, see how to remove duplicates in Excel<\/a>.<\/p>\n 1.<\/strong> Type the UNIQUE function followed by the FILTER function and select the array.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-filter-function-unique-formula.png” alt=”Excel FILTER with UNIQUE \u2014 =UNIQUE(FILTER(A2:H1001 typed in cell J2 with FILTER in the suggestion list” title_text=”=UNIQUE(FILTER(A2:H1001 typed in cell J2 with FILTER in the suggestion list” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Add the condition. In this case, amounts must be larger than $1000.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-filter-function-unique-condition.png” alt=”Excel FILTER with UNIQUE \u2014 condition F2:F1001 greater than 1000 inside the UNIQUE and FILTER formula” title_text=”Condition F2:F1001 greater than 1000 inside the UNIQUE and FILTER formula” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Close the parentheses and press \u2018Enter\u2019 to see the results.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-filter-function-unique-results.png” alt=”Excel FILTER with UNIQUE \u2014 unique records with amounts over 1000 returned from cell J2″ title_text=”Unique records with amounts over 1000 returned from cell J2″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Finally, let\u2019s see how to use the SORT function to sort the results returned by FILTER.<\/p>\n 1.<\/strong> Type the SORT function, followed by the FILTER function, and select the array.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-filter-function-sort-formula.png” alt=”Excel FILTER with SORT \u2014 =SORT(FILTER(A2:H1001 typed in cell J2″ title_text=”=SORT(FILTER(A2:H1001 typed in cell J2″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 2.<\/strong> Add the condition and the closing parenthesis. In this case, I want records belonging to Agent1.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-filter-function-sort-condition.png” alt=”Excel FILTER with SORT \u2014 condition G2:G1001=Agent1 with the sales_agent column outlined” title_text=”Condition G2:G1001=Agent1 with the sales_agent column outlined” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 3.<\/strong> Add the number of the column you want to sort by. In this example, I want to sort by the amount in the sixth column. After the semicolon, select the order you want: ascending (1) or descending (-1).<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-filter-function-sort-options.png” alt=”Excel FILTER with SORT \u2014 sort index 6 typed and the 1 Ascending and -1 Descending options listed” title_text=”Sort index 6 typed and the 1 Ascending and -1 Descending options listed” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n 4.<\/strong> Close the parenthesis and press \u2018Enter\u2019 to see the result.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-filter-function-sorted-results.png” alt=”Excel FILTER with SORT \u2014 Agent1 records sorted by amount in descending order from cell J2″ title_text=”Agent1 records sorted by amount in descending order from cell J2″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”transfer-filtered-data-between-workbooks” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n With Sheetgo, an AI-powered data automation platform, you can easily transfer filtered data between Excel workbooks and set up automatic updates to refresh it without having to write a single formula.<\/p>\n Simply select your source file and choose the filter you want to use: condition, query, or cell color. Once you\u2019ve set up the filters, select the destination file and run the connection to transfer the data. If this is a recurring task, you can easily save this connection and schedule automatic updates.<\/p>\n To learn more about this, check out this post on how to transfer filtered data between different workbooks<\/a>. For a quick one-off filter, you can also try our free filter by condition tool<\/a>.<\/p>\n [\/et_pb_text][et_pb_text module_id=”conclusion” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The Microsoft Excel FILTER function is very flexible and easy to use. You can reproduce filtered versions of your array without affecting the original data. Since it remains linked, the filtered array will be updated with changes to the original as soon as the formula refreshes. You can use multiple conditions within the same formula and apply them to the same column or different ones. Additionally, you can combine FILTER with other functions to operate on or manipulate the results.<\/p>\n You now know how to use Excel\u2019s FILTER function to filter records based on exact text matches, numerical comparisons, and dates. You also know how to combine multiple conditions by using the AND (*) and OR (+) symbols. Finally, you know how to combine FILTER with UNIQUE to get only unique records matching your criteria and how to combine it with SORT to get a filtered and sorted version of the array.<\/p>\n If you\u2019re not a fan of long and complex formulas, you also know there’s a great alternative: Sheetgo<\/a>, an AI-powered data automation platform. Instantly connect your source and destination files and choose which filters you want to apply. Let Sheetgo do the heavy lifting so you can focus on what matters. Sign up for free and start saving time today<\/a>.<\/p>\n To learn more about Google Sheets or Microsoft Excel, check out our guides on:<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Aprende a usar la funci\u00f3n FILTER (FILTRAR) de Excel para filtrar datos por texto, n\u00famero y fecha, con varias condiciones y junto con UNIQUE y SORT.<\/p>","protected":false},"author":2,"featured_media":264782,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[65],"tags":[],"class_list":["post-264757","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-functions"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/264757","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=264757"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/264757\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/264782"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=264757"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=264757"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=264757"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}FILTER function syntax<\/h2>\n
\n
\n
How to use FILTER function in Excel?<\/h2>\n
FILTER by text<\/h3>\n
FILTER by numerical value<\/h3>\n
FILTER by date<\/h3>\n
Use the Excel FILTER function with multiple conditions<\/h2>\n
Excel FILTER multiple conditions with OR<\/h3>\n
Excel FILTER multiple conditions with AND<\/h3>\n
Use FILTER with other functions<\/h2>\n
Excel FILTER with UNIQUE<\/h3>\n
Excel FILTER with SORT<\/h3>\n
Transfer filtered data between workbooks with Sheetgo<\/h2>\n
Conclusion<\/h2>\n
\n