Formulas & functions
How a function works, with worked examples you can paste.
- Excel Formula to Calculate Age From a BirthdayIn Excel for Microsoft 365, use =DATEDIF(A2,TODAY(),"Y") to calculate someone’s age in completed years, assuming the birthday is a real Excel date…
- Excel Formula to Calculate Your Age from Birth DateIf the birth date is in cell A2, enter =DATEDIF(A2,TODAY(),"Y") to calculate age in completed years as of today. For example, if…
- Excel Formula Bar Not Showing Text? Fixes That WorkIf Excel’s formula bar is missing, turn it back on with View > Show > Formula Bar in Excel for Microsoft 365…
- Excel Formula to Build a Table AutomaticallyYes—Excel formulas can build a changing, table-shaped result, but a formula cannot create an actual Excel Table object. With headings in A1:C1,…
- Excel FORECAST vs TREND: Which Function to Use?In Excel, FORECAST.LINEAR predicts one value from a linear relationship, while TREND calculates one or more values from that same kind of…
- Excel Format A to Z: How to Sort Rows and Lists SafelyTo sort data from A to Z in Excel for Microsoft 365 on Windows, click a cell in the column you want…
- Excel Find and Substitute Formula: Examples and TipsTo find text and replace it in an Excel formula, use SUBSTITUTE: it replaces matching text in a cell, either every occurrence…
- Excel Find and Remove Text: Replace, Formulas, and TipsTo find and remove text in Excel, press Ctrl+H, enter the text in Find what, leave Replace with empty, and choose Replace…
- Excel Filter With Multiple Criteria: A Practical GuideTo filter a worksheet by more than one condition in Excel for Microsoft 365 on Windows, select your data and choose Data…
- Excel Filter to Show Duplicates: A Practical GuideTo show duplicate values in Excel, select the column, choose Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values, then…
- Excel FILTER and XLOOKUP: How to Use Them TogetherYes. In Excel for Microsoft 365, you can use XLOOKUP to find a value and FILTER to return every row that matches…
- Excel Filter Table Multiple Criteria: Practical MethodsTo filter an Excel table by multiple criteria, use the filter arrows in its column headings: set criteria in different columns to…
- Excel Filter Table Without Hiding Rows: Best OptionsExcel’s built-in filters hide rows that do not match, so you cannot use a standard table filter to show only matching records…
- Excel Filter Table by Keyword: Steps, Options, and TipsTo filter an Excel table by keyword, open the filter arrow in the column you want to search, type a word or…
- Excel Filter Returns Numbers as Dates? Here’s WhyExcel’s filter feature does not turn numbers into dates; it either shows existing cell values or returns values whose display is controlled…
- Excel Filter: Select Multiple Values with a ShortcutIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter on or off; this shortcut does not select multiple filter…
- Excel Filter Partial Text Match: Find Text in CellsYes. In Excel for Microsoft 365 on Windows, turn on a column’s filter, open its dropdown, and choose Text Filters > Contains…
- Excel Filter Out Text: Keep Numbers or Hide WordsTo filter text out of a mixed Excel column and keep numeric rows, use a helper column with ISNUMBER, then filter the…
- Excel Filter Numbers From Text: Formulas and StepsTo filter Excel rows where a text cell contains one or more digits, add a helper column with =SUMPRODUCT(--ISNUMBER(SEARCH({0,1,2,3,4,5,6,7,8,9},A2)))>0, fill it down,…
- Excel Filter Only Show Duplicates: A Practical GuideExcel does not have a built-in AutoFilter command that directly displays only duplicate values, but you can add a helper column, mark…
- Excel Filter Out Errors: Quick Methods That WorkTo filter out error rows in Excel for Microsoft 365 on Windows, select your data, choose Data > Filter, open the filter…
- Excel Filter Not Grouping Dates by Month? Causes and FixesIf Excel’s filter dropdown is not grouping dates by month, first check that every value in the date column is a real…
- Excel Filter Not Equal to Text? How to Exclude ValuesTo filter out a particular text value in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data…
- Excel Filter Multiple Sheets by Criteria: Best MethodsExcel’s built-in Filter command works on one table or data range at a time; it does not apply one shared filter across…
- Excel Filter No Duplicates? Show Unique ValuesExcel’s regular AutoFilter does not have a one-click option to show only unique values. To hide duplicate records without deleting them, use…
- Excel Filter Merged Cells: Why Only the First Row ShowsYes—when a cell is merged vertically across several rows, Excel stores its value only in the top-left cell, so a filter does…
- Excel Filter Multiple Criteria in One Column: How It WorksTo filter one Excel column for several allowed values, select the column’s filter arrow and check each value you want to keep;…
- Excel Filter Multiple Criteria in the Same Column?To filter one Excel column by several values, open its filter dropdown and select each value you want to keep; Excel combines…
- Excel Filter Including Wrong Data? Find the CauseIf an Excel filter includes the wrong data, first check that the filter covers the correct range and that the column has…
- Excel Filter Multiple Criteria: AND, OR, and ExamplesYes. In Excel, use a column’s filter checklist to show several selected values (OR), or apply filters to different columns to require…