Formulas & functions
How a function works, with worked examples you can paste.
- Excel Consolidate Function: How to Combine DataTo use Excel’s Consolidate function, select the top-left cell for the results, then choose Data > Consolidate, select a function such as…
- Excel Heat Map: Apply a Formula to Color CellsTo apply a formula to an Excel heat map, select the cells, choose Home > Conditional Formatting > New Rule > Use…
- Excel: How to Hide Columns to the Right of Your DataTo hide every column to the right of your data in Excel for Microsoft 365 on Windows, select the first column you…
- Excel Goal Seeking: Find a Target Value with What-If ToolsExcel Goal Seek finds the input value that makes a formula return a result you specify. In Excel for Microsoft 365 on…
- Excel Formula to Split Text in a Cell: A Practical GuideIn Excel for Microsoft 365, split text in a cell with =TEXTSPLIT(A2,","), replacing the comma with the character that separates your text.…
- Excel Formula to Remove Duplicates From One ColumnIn Excel for Microsoft 365 or Excel 2021, enter =UNIQUE(A2:A100) in an empty cell to return a live list of distinct values…
- Excel Formula Not Calculating Until You Press Enter?If an Excel formula updates only after you press Enter, first check whether calculation is set to Automatic: in Microsoft 365 for…
- Excel Formula to Password Protect a Sheet? What WorksNo Excel formula can password-protect a worksheet: formulas calculate values, but they cannot set sheet permissions or require a password for editing.…
- Excel Formula Solver: Goal Seek, Solver, and How to Use ThemExcel does not have a worksheet function called “formula solver.” To make Excel find an input that produces a target result, use…
- Excel Equation to Remove Duplicates: Formulas & StepsIn Microsoft 365, use =UNIQUE(A2:A100) to return a list of distinct values from A2:A100. This formula leaves the original data untouched; to…
- Excel Won’t Calculate Formulas? Causes, Checks, and FixesIf Excel does not calculate a formula, first check Formulas > Calculation Options and select Automatic. If that does not solve it,…
- Excel Data Validation INDIRECT: Dependent Drop-DownsYes. In Excel, use INDIRECT in a data-validation list to make a drop-down depend on a selection in another cell: create a…
- Excel Consolidate Text Data: Formulas and Power QueryTo consolidate text in Excel, join cells with TEXTJOIN or combine rows from multiple tables with Power Query. With text parts in…
- Excel Consolidate Text: Formulas, Flash Fill, and Power QueryTo consolidate text from Excel cells, use TEXTJOIN when you want a separator and control over blank cells, or join values directly…
- Excel Consolidate Blank Cells Into One Cell With TEXTJOINYes—if by “blank wells” you mean blank cells between values, Excel can combine the nonblank entries into one cell with TEXTJOIN. With…
- Excel Conditional Formatting: Use a Formula for RulesYes. In Excel, conditional formatting can use a formula that evaluates to TRUE or FALSE to decide which cells receive a chosen…
- Excel Compare Two Sheets Cell by Cell: Formulas and ToolsYes. In Excel for Microsoft 365 on Windows, compare matching cells on two sheets with a formula such as =Sheet1!A1=Sheet2!A1; it returns…
- Excel Compare Two Sheets: Tools, Formulas, and TipsTo compare two Excel sheets, use Spreadsheet Compare if it is available in your Microsoft 365 or Office edition: open the Inquire…
- Excel Compare Columns in Two Sheets: Methods and FormulasTo compare values in the same row, put this formula in a spare column and fill it down: with corresponding values in…
- Excel Compare Duplicates Between Two Sheets: FormulasTo compare values in two Excel sheets, enter a formula beside the first list and check whether each value appears in the…
- Dynamic Named Range Excel Formula: Setup and ExamplesA dynamic named range in Excel is a named reference that expands or contracts as entries are added or removed. For a…
- DAX Function in Excel: What It Does and How to Use ItDAX in Excel is a formula language for calculations in the workbook Data Model, used through Power Pivot and PivotTables—not a function…
- DAX Formula in Excel: How It Works and ExamplesA DAX formula in Excel is an expression used in the Excel Data Model to create a measure or calculated column; it…
- Compare Two Sheets in Excel: Methods, Formulas, and TipsTo compare two Excel sheets, check corresponding cells with a formula such as =IF(January!A2=February!A2,"Match","Different"), then fill it across the data; for sheets…
- Compare Rows in Two Excel Sheets: Formulas and MethodsTo compare rows in two Excel sheets, compare corresponding cells when the rows are in the same order, or match records by…
- Split Cells in Excel: Text to Columns and FormulasTo split the contents of a cell in Excel, select the cells, then choose Data > Text to Columns, pick Delimited or…
- Calculating r in Excel: Formula and ExamplesTo calculate Pearson’s correlation coefficient, or r, in Excel, use =CORREL(A2:A6,B2:B6) when the paired x values are in A2:A6 and their corresponding…
- Bing Chat Excel Formula Not Responding?If Bing Chat is not responding to an Excel formula, first check whether the problem is the chat tool or Excel itself:…
- Bing Chat Excel Formula Not Calculating? Causes & FixesIf a formula from Bing Chat is not calculating, first paste it into an Excel cell and confirm it begins with =;…
- Excel UNIQUE Function Not Showing? Causes and FixesIf Excel does not recognize or display UNIQUE, first check your version: the function is available in Microsoft 365 and Excel 2021…