Formulas & functions
How a function works, with worked examples you can paste.
- Excel Filter Dates by Day of Week: Methods That WorkExcel’s date filter menu does not include a direct day-of-week option, but you can filter weekdays by adding a helper column and…
- Excel Filter Dates by Month: Quick Steps and FixesTo filter dates by month in Excel, select a cell in your date column, choose Data > Filter, open the column’s filter…
- Excel Filter Contains Text: Steps, Wildcards, and FixesYes. In Excel for Microsoft 365 on Windows, open the filter arrow on the text column, choose Text Filters > Contains, enter…
- Excel Filter Data Validation List: Setup and LimitsYes—updated Microsoft 365 versions of Excel can autocomplete a data-validation dropdown as you type, narrowing the choices to matching entries. For a…
- Excel Filter Dates Before Today: Steps That WorkTo filter Excel dates before today, open the date column’s filter menu and choose Date Filters > Before, then enter today’s date.…
- Excel Filter Contains Partial Text? Find MatchesYes. In Excel for Microsoft 365 on Windows, open the column’s filter menu and choose Text Filters > Contains, enter the word…
- Excel Filter Multiple Criteria in One Column: 5 MethodsTo filter one Excel column by multiple criteria, open its filter dropdown and select several values, or choose a custom filter to…
- Excel Filter Command for Multiple Criteria ExplainedIn Excel for Microsoft 365 on Windows, use Data > Filter, then set a condition from each relevant column’s dropdown: criteria in…
- Excel Filter Cells Containing Specific TextTo filter Excel rows for cells containing particular text, select a cell in your data, choose Data > Filter, open the column’s…
- Excel Filter Cells Containing Text: Steps and OptionsTo filter Excel cells that contain a particular word or phrase, select your data, choose Data > Filter, open the column’s filter…
- Excel Filter by Bold Text: Methods That Actually WorkExcel’s standard filter cannot directly identify or filter rows by bold text. To filter them, add a helper column that records whether…
- Excel Filter by Partial Text: How to Find MatchesTo filter Excel rows by text found anywhere in a cell, select a cell in your data, choose Data > Filter, open…
- Excel Filter Button Shortcut: Keys, Menus, and FixesIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn filter buttons on or off for a data range. On a…
- Excel Filter by Text Length: Steps and FormulasTo filter Excel rows by the number of characters in a text cell, add a helper column with =LEN(A2), fill it down,…
- Excel Filter: Begins With Multiple Criteria in Microsoft 365Yes. In Excel for Microsoft 365 on Windows, choose Data > Filter, open the column’s filter menu, then select Text Filters >…
- Excel Filter Between Text Ranges: Steps and LimitsYes. In Excel for Microsoft 365 on Windows, open the column’s filter menu, choose Text Filters > Custom Filter, and set two…
- Excel Filter Between Two Dates: Steps and Common FixesTo filter Excel dates between two limits, open the filter arrow in the date column, choose Date Filters > Between, enter the…
- Excel Filter Based on 2 Criteria: AND or ORTo filter Excel data using two criteria, apply a filter to two columns: Excel combines those conditions with AND, showing rows that…
- Excel Filter Based on Multiple Criteria: How It WorksTo filter Excel data by multiple criteria, use Data > Filter and set a condition in each relevant column; Excel keeps rows…
- Excel: How to Filter a Table Based on a List of ValuesYes. In Excel for Microsoft 365, you can return only the rows in a table whose values appear in a separate list…
- Excel Filter All Rows Containing Text in a ColumnTo filter Excel rows that contain a word or phrase, open the filter arrow in the relevant column and choose Text Filters…
- Excel FILTER With Multiple Criteria: AND and ORTo filter an Excel list by multiple conditions, use the FILTER function and combine its criteria: multiply conditions for AND, or add…
- Excel Dynamic Array Filter Multiple Criteria?Use Excel’s FILTER function and combine criteria with multiplication for AND or addition for OR. With order data in A2:D7 (Order, Region,…
- Excel Dynamic Filter Multiple Criteria: Formulas and TipsTo dynamically filter rows in Excel by multiple conditions, use the FILTER function and combine criteria with multiplication for AND or addition…
- Excel Drop-Down List with INDIRECT: Setup and FixesYes. To make a dependent drop-down list in Excel, create named ranges for the choices and use =INDIRECT($A2) as the second list’s…
- Excel Formula Not Updating When Dragging Down? FixesIf an Excel formula does not update when you drag it down, first check that you are dragging the fill handle, then…
- Excel Difference Between Dates: Formulas and ExamplesTo find the number of days between two dates in Excel, subtract the earlier date from the later one: with a start…
- Excel DGET vs INDEX MATCH: Which Should You Use?For a normal lookup by one key, INDEX MATCH is usually the straightforward choice; DGET is useful when you want to define…
- Excel Dependent Drop-Down Lists with XLOOKUPYes—Excel for Microsoft 365 can use XLOOKUP to return the options for a dependent drop-down, but XLOOKUP does not create the drop-down…
- Excel Dependent Drop-Down List with VLOOKUP ExplainedYes—you can use a dependent drop-down list with VLOOKUP, but they do different jobs. Data Validation creates the drop-downs, with the second…