Formulas & functions
How a function works, with worked examples you can paste.
- Microsoft Excel Filter Duplicates: Find or Remove ThemExcel does not have a dedicated “filter duplicates” command in a column’s filter menu. To show repeated records, add a helper column…
- Microsoft Excel Date Today: TODAY Formula and Useful TipsTo show today’s date in Microsoft Excel for Microsoft 365 on Windows, enter =TODAY() in a cell and press Enter. Excel returns…
- Excel DATEDIF Function: Calculate Years, Months, and DaysMicrosoft Excel’s DATEDIF function calculates the difference between two dates in complete years, months, or days, or in combinations such as years…
- Excel COUNTIF for Text: Examples and Common FixesTo count cells that match text in Microsoft Excel, use =COUNTIF(A2:A20,"Apple"), replacing the range and word with your own. COUNTIF can also…
- Excel COUNTIF for Text That Contains a WordTo count cells that contain a particular word or phrase anywhere in their text, use Excel’s COUNTIF function with an asterisk on…
- Microsoft Excel COUNTIF Formula: Syntax and ExamplesIf product names are in A2:A100, count cells containing Apples with =COUNTIF(A2:A100,"Apples"). COUNTIF counts cells in a range that meet one condition,…
- Microsoft Excel Concatenate Text: Formulas and ExamplesTo concatenate text in Microsoft Excel, join cell contents with the ampersand operator (&), or use CONCAT or TEXTJOIN. For example, with…
- Microsoft Excel Calendar Formula: Build a Monthly ViewIn Microsoft Excel for Microsoft 365, enter a year in B1 and a month number in C1, then put this formula in…
- Excel AVERAGEIF: Syntax, Examples, and Common FixesIn Microsoft Excel, use =AVERAGEIF(range,criteria,average_range) to average values that meet one condition. For example, if categories are in A2:A7 and amounts are…
- How to Merge Two Sheets in Excel with VLOOKUP FormulasTo merge information from two Excel sheets by a shared ID, add a column to the sheet you want to keep and…
- Max Value Between Two Dates in Excel: Formula GuideTo find the largest value recorded between two dates in Excel, use =MAXIFS(C2:C100,A2:A100,">="&E2,A2:A100,"<="&F2). This assumes dates are in A2:A100, the values to…
- Excel PMT Function for Mortgage Payments ExplainedExcel’s PMT function calculates the regular payment on a fixed-rate mortgage when you give it the interest rate per payment period, the…
- Match in Excel Without Duplicates: Formulas That WorkTo return values that appear in both Excel lists without repeating them, use =UNIQUE(FILTER(A2:A100,(A2:A100<>"")*ISNUMBER(XMATCH(A2:A100,B2:B100)),"")). With the first list in A2:A100 and the…
- Match Names on Two Excel Sheets with VLOOKUPYes. VLOOKUP can find a name on one Excel sheet in a second sheet and return a related value from that row.…
- Mac Excel Filter Shortcut: Turn Filters On and Use ThemIn Excel for Mac, press Command+Shift+F to turn AutoFilter on or off for a data range. Select a cell in the range…
- List Excel Sheet Tabs with a Formula: Methods That WorkIf you mean worksheet tabs, Excel has no built-in worksheet formula that directly lists their names. A legacy Excel 4 macro function,…
- Lowercase in Excel: Shortcut, Formula, and Fast FixesExcel has no built-in keyboard shortcut that directly changes selected text to lowercase. The dependable option is the LOWER function: with the…
- LEN SUBSTITUTE Excel Formula: Count Characters or TextTo count how many times a character appears in a cell, subtract the length of the text after removing that character from…
- VLOOKUP in Excel: Step-by-Step GuideTo use VLOOKUP in Excel, put the value you want to find in the first column of a lookup table, then enter…
- Excel Filter Shortcut: Turn AutoFilter On or OffIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn the filter buttons on or off. The shortcut adds or removes…
- Excel Find Shortcut: Search Cells, Formulas, and MoreIn Excel for Microsoft 365 on Windows, press Ctrl+F to find text, numbers, or other content in a worksheet. On a Mac,…
- Shuffle a List in Excel: Formulas, Sorting, and TipsYes. In Microsoft 365, you can shuffle a list with a formula using SORTBY and RANDARRAY; in any recent Excel version, you…
- How to Shuffle Cells in Excel: Formulas and Safe StepsYes. Excel has no single Shuffle command, but you can randomize a list or whole rows by adding a RAND() helper column…
- Filter Duplicates in Excel: Find, Keep, or Remove ThemYes. In Excel for Microsoft 365 on Windows, you can filter duplicate records by adding a helper column with a COUNTIF formula,…
- IRR in Excel: Formula, Examples, and Common ErrorsYes. In Excel for Microsoft 365 on Windows, use the IRR function to estimate the return for a series of cash flows…
- Inventory Management in Excel Using VLOOKUP: Setup GuideYes. Create a product master with each unique SKU in its leftmost column, then use VLOOKUP to bring product details into an…
- Interpolate Between Two Points in Excel With a FormulaTo interpolate between two points in Excel, use a straight-line formula: estimated y = y1 + (target x − x1) × (y2…
- Sort a List in Excel: Steps and Custom SortsTo sort a list in Excel, click a cell in the list, then choose Data > Sort A to Z or Data…
- Insert Images in Excel Cells With the IMAGE FormulaYes. In Excel for Microsoft 365, use the IMAGE function to show an online picture inside a cell. With a direct HTTPS…
- Excel INDIRECT Across Sheets: How to Reference Other TabsYes. Excel’s INDIRECT function can refer to a cell or range on another sheet when you build that sheet reference as text.…