Formulas & functions
How a function works, with worked examples you can paste.
- Rank in Excel With Ties: RANK.EQ and Unique RanksTo give equal values the same rank in Excel, enter a RANK.EQ formula. With scores in B2:B6, put =RANK.EQ(B2,$B$2:$B$6,0) in C2 and…
- Rank in Excel Without Duplicates: Formula and StepsTo give every numeric value a distinct rank in Excel, use RANK.EQ to find its position and COUNTIF to add one for…
- How to Randomize Names in Excel With a Simple FormulaTo randomize names in Excel, add a helper column and use a random number for each row. With names in A2:A20, enter…
- Excel Caps to Lowercase: Quick Steps and FormulaTo change all-caps text to lowercase in Excel, put the original text in A2:A6 and enter =LOWER(A2) in B2. Fill the formula…
- VLOOKUP Between Two Excel Sheets: Simple Step-by-Step GuideTo return a value from one Excel sheet based on a match in another, enter a VLOOKUP formula on the sheet where…
- How to Put an XLOOKUP Formula in Excel: Step-by-StepTo put an XLOOKUP formula in Excel, select the cell where you want the answer, then enter a formula that identifies the…
- How to Put a Search Bar in an Excel Column and FilterTo search a column quickly, select a cell in your data and choose Data > Filter; open that column’s header dropdown, type…
- Excel Filter Shortcut: How to Turn It On and Use ItTo put a filter in Excel on Windows, click a cell in your data and press Ctrl+Shift+L. Excel adds a drop-down arrow…
- How to Put a Filter in Excel to Find Data More EasilyTo put a filter in an Excel sheet, click a cell in your data and select Data > Filter. Excel adds a…
- Excel Formula Color: How to Use Conditional FormattingYou cannot make a standard Excel formula directly change a cell’s font or fill color. To color cells based on a formula,…
- Calendar in Excel: Create a Monthly Calendar With a FormulaTo put a calendar in Excel, enter a year in B1 and a month number in B2, add weekday headings, then place…
- How to Put a SUM Formula in an Excel Column of NumbersTo total numbers in an Excel column, select the cell where the answer should appear, type a SUM formula such as =SUM(B2:B6),…
- Paste Numbers in Excel Without Formulas: Paste ValuesTo paste formula results as fixed numbers in Excel, copy the cells, select the destination, then choose Home > Paste > Values…
- How to Paste in Excel Without Formulas and Keep ValuesTo paste in Excel without copying formulas, copy the cells, select the destination, then choose Home > Paste > Values (the clipboard…
- How to Paste in Excel When a Filter Is Applied SafelyTo paste into a filtered Excel list without changing hidden rows, select the destination cells, choose Home > Find & Select >…
- How to Paste Formulas in Excel Without Changing ThemTo paste a formula into another cell without Excel adjusting its cell references, copy the formula text from the formula bar and…
- Paste a Formula in Excel Down a Column: Step-by-StepTo paste a formula down a column in Excel, enter it in the first cell, select that cell and the cells below…
- How to Open Filter in Excel With a Keyboard ShortcutTo turn filters on or off in Excel for Microsoft 365 on Windows, select a cell in your data and press Ctrl+Shift+L.…
- How to Multiply in Excel in the Same Cell: FormulasTo multiply in Excel and show the answer in a cell, select that cell, type a formula beginning with an equals sign,…
- How to Multiply in Excel: Formulas and ExamplesTo multiply in Excel, enter an equals sign, the first number or cell reference, an asterisk, and the next number or cell…
- How to Match Two Excel Sheets with VLOOKUP in ExcelTo match records between two Excel sheets, put the value you want to find in the first column of the lookup range,…
- How to Make a Filter in Excel: Step-by-StepTo make a filter in Excel for Microsoft 365 on Windows, click a cell in your data, then choose Data > Filter.…
- How to Make Excel Sort Dates Correctly, Oldest FirstTo make Excel sort dates correctly, first ensure the date cells contain real Excel dates rather than text, then select the entire…
- Lock a Number in an Excel Formula with $ ReferencesTo keep a number fixed when you copy a formula, put the number in a worksheet cell and lock that cell reference…
- How to Interpolate in Excel with a Simple FormulaTo interpolate in Excel, use a straight-line formula between the two known data points that surround your target value. With x-values in…
- Insert Images in Excel With the IMAGE Formula Step by StepTo insert an image in an Excel cell with a formula, use the IMAGE function with a direct image URL, such as…
- How to Insert a Filter in Excel to Sort and Find DataTo insert a filter in Excel for Microsoft 365 on Windows, click a cell in your data range, then choose Data >…
- Insert a Checkbox in Excel Using a Formula: Step-by-StepTo show a formula-driven checkbox in Excel, put a TRUE or FALSE value in A2 and, with that value in A2, enter…
- Insert a Check Box in Excel and Use It in a FormulaTo use a check box in an Excel formula, insert a check box into a cell, then refer to that cell in…
- How to Insert a Filter in an Excel Column, Step by StepTo insert a filter in an Excel column, click a cell inside your data range, then select Data > Filter. Excel adds…