Formulas & functions
How a function works, with worked examples you can paste.
- Excel Won’t Let Me Filter by Color? Fixes That WorkExcel usually lets you filter a column by cell color, font color, or icon from its filter drop-down: choose Filter by Color…
- Excel Filter by Cell Colour: Steps, Limits and FixesTo filter by cell colour in Excel for Microsoft 365 on Windows, select a cell in your data, turn on filtering with…
- Excel Filter by Color and Value: How It WorksYes. In Excel for Microsoft 365 on Windows, open a column’s filter menu and choose a color under Filter by Color; to…
- Excel Filter and Sort by Color: Steps, Options, and TipsIn Excel for Microsoft 365 on Windows, use the filter arrow in a column and choose Filter by Color to show rows…
- How to Split Cell Data in Excel: Text to Columns & FormulasTo split cell data in Excel, select the cells, choose Data > Text to Columns, pick Delimited or Fixed width, set the…
- Split Names in Excel: Text to Columns and FormulasTo split names into separate Excel cells, select the name column and choose Data > Text to Columns > Delimited, then select…
- Split a Cell in Excel: Columns, Formulas, and LimitsTo split text from one Excel cell into separate columns, select the column, then choose Data > Text to Columns and follow…
- Combine Cells in Excel Without Merging: Formulas and StepsTo combine the contents of cells without merging them, put the result in a separate cell with a formula. With a first…
- Combine Cells in Excel for Names: Formulas and StepsTo combine a first name in A2 and a last name in B2, enter =A2&" "&B2 in C2 and press Enter; it…
- Remove Duplicates in Excel Filter: A Step-by-Step GuideTo remove duplicate rows in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data > Remove Duplicates,…
- COUNTA Across Multiple Excel Sheets: Formulas and TipsTo count nonempty cells in the same range across consecutive worksheets, use =COUNTA(Jan:Mar!A2:A100). This assumes the Jan, Feb, and Mar sheets each…
- Count Excel Without Duplicates: Formulas That WorkTo count distinct, nonblank values in Excel for Microsoft 365, use =IFERROR(ROWS(UNIQUE(FILTER(A2:A100,A2:A100<>""))),0), replacing A2:A100 with your data range. The formula returns the…
- Count Excel Rows After a Filter: Formulas That WorkTo count rows currently visible after filtering, use SUBTOTAL on a column that has a value in every data row. With nonblank…
- Text After in Excel: Formula, Examples, and FixesTo return the text after a delimiter in Excel for Microsoft 365 on Windows, use =TEXTAFTER(A2,"-"). This assumes A2 contains the text…
- Excel XIRR With Dates: Formula, Examples, and FixesTo calculate a return from cash flows that happen on specific, uneven dates, use Excel’s XIRR function: with cash flows in B2:B4…
- Excel NPV Calculation: Steps, Formula, and ExamplesTo calculate NPV in Excel, put the discount rate in one cell, list future cash flows in period order, and use =NPV(rate,future_cash_flows)+initial_investment.…
- Excel Letter to Number: Convert Column Labels in FormulasTo convert an Excel column letter to its number, place the label in A2 and enter =COLUMN(INDIRECT(UPPER(A2)&"1")) in B2. For example, if…
- Excel Let Text Spill Into the Next Cell? How It WorksYes. In Excel for Microsoft 365, text can appear to spill into the cell to its right when that neighboring cell is…
- Excel Let Cell Overflow? How to Show Text Across CellsYes. In Excel for Microsoft 365 on Windows, text can overflow into the cells to its right when those cells are empty;…
- Excel SEQUENCE Without Gaps: Create a Continuous Number ListYes. In Microsoft 365 or Excel 2021, enter =SEQUENCE(10) in an empty cell to create the continuous list 1 through 10, with…
- Excel SEQUENCE: Create Automatic Number SequencesYes. In Microsoft Excel for Microsoft 365, enter a SEQUENCE formula to generate a series automatically: with an empty worksheet and the…
- Excel SEQUENCE Shortcut: Fast Ways to Create a SeriesExcel has no dedicated keyboard shortcut for the SEQUENCE function. In Microsoft 365 or Excel 2021 and later, type a formula such…
- Sequence Excel Without Duplicates: Formulas & TipsTo create a duplicate-free sequence in Excel for Microsoft 365, enter =SEQUENCE(10) in an empty cell; it spills the numbers 1 through…
- Excel Extend Number Sequence: Fill Series and FormulasTo extend a number sequence in Excel, enter its first two values, select both cells, then drag the fill handle—the small square…
- Excel Paste Unique Values: Remove Duplicates or Use a FormulaTo paste unique values in Excel, use Data > Advanced to copy distinct records to another location, or use Remove Duplicates on…
- Unique in Excel: Get Values Without DuplicatesTo list each value once in Excel for Microsoft 365, enter =UNIQUE(A2:A10) in an empty cell, replacing A2:A10 with your data range.…
- Sort Excel Numbers in Order: Steps, Formulas, and FixesTo sort numbers in Excel, select a cell in the number list and choose Data > Sort & Filter > Sort Smallest…
- Sort Excel by Color: Steps, Options, and TroubleshootingTo sort an Excel sheet by color in Microsoft 365 for Windows, select a cell in your data, go to Data >…
- Excel Sort Shortcut: Sort Your Data Quickly and SafelyIn Excel for Microsoft 365 on Windows, press Alt, A, S, S in sequence to open the Sort dialog. For a quick…
- Sort an Excel Column Highest to Lowest: Quick StepsTo sort numbers in Excel from highest to lowest, select a cell in the column and choose Data > Sort Largest to…