Formulas & functions
How a function works, with worked examples you can paste.
- How to Indent in the Excel Formula BarTo indent a formula in Excel’s formula bar, edit the formula, insert a line break with Alt+Enter on Windows, then add spaces…
- How to Highlight in Excel Using a FormulaTo highlight cells or entire rows in Excel based on a condition, select the range, then choose Home > Conditional Formatting >…
- Excel COUNTIF: How to Count Cells That Match a RuleTo count cells that meet one condition in Microsoft Excel, use =COUNTIF(range,criteria). For example, with status values in B2:B11, =COUNTIF(B2:B11,"Paid") counts cells…
- Freeze Values in Excel Formulas: A Step-by-Step GuideTo stop a formula result changing, copy the formula cell or range and paste it back as values: select the cells, press…
- Freeze a Number in an Excel Formula with $ ReferencesTo freeze a number’s cell reference when you copy an Excel formula, add dollar signs to the reference—for example, change F1 to…
- Flip Names in Excel With a Comma Using a FormulaTo change names such as Mary Ann Smith to Smith, Mary Ann, put the original name in A2 and enter a formula…
- Flip Names in Excel in the Same Cell With a FormulaTo flip a name such as John Smith to Smith John in Excel for Microsoft 365, enter a formula in a temporary…
- How to Find Unique Names in an Excel Column EasilyIn Microsoft 365, you can create a live list of distinct names with the UNIQUE function. With names in A2:A100, enter =UNIQUE(FILTER(A2:A100,A2:A100<>""))…
- How to Find the Minimum in Excel with the MIN FunctionTo find the smallest number in Excel, use the MIN function. With the numbers you want to check in cells A2 through…
- Find a Percentage in Excel: Formulas, Examples, and TipsTo find what percentage one value is of another in Excel, divide the part by the total, then format the result as…
- Rank in Excel Formula: Use RANK.EQ and Handle TiesTo find a number’s position in a list in Microsoft Excel, use RANK.EQ. For example, if scores are in B2:B7, enter =RANK.EQ(B2,$B$2:$B$7,0)…
- Find Names in Excel Using VLOOKUP: Step-by-Step GuideTo find a name and return a related value, put the name you want to search for in a cell, then use…
- How to Find the Lowest Value in Excel with the MIN FunctionIf your numbers are in B2:B7, enter =MIN(B2:B7) in an empty cell; Excel returns the smallest number in the range. For example,…
- Find Lowercase Letters in Excel with Formulas and FiltersTo find cells containing at least one lowercase letter, put the text in A2 and enter =IF(A2="",FALSE,LET(chars,MID(A2,SEQUENCE(LEN(A2)),1),SUMPRODUCT(--EXACT(chars,LOWER(chars)),--NOT(EXACT(chars,UPPER(chars))))>0)) in B2. Fill the formula…
- How to Find the Lowest Number in Excel with MIN FormulaTo find the lowest number in a range, enter =MIN(A2:A20) in an empty cell, replacing A2:A20 with the cells you want to…
- How to Find IQR in Excel With QUARTILE FunctionsTo find the interquartile range (IQR) in Excel, subtract the first quartile from the third quartile: use =QUARTILE.INC(A2:A9,3)-QUARTILE.INC(A2:A9,1) when your numbers are…
- Find the Highest Value in Excel with the MAX FunctionTo find the highest number in an Excel range, enter =MAX(B2:B20) in an empty cell, replacing B2:B20 with your range. Excel returns…
- Excel Grade Formula: Find Letter Grades From ScoresTo turn a score into a letter grade in Excel, create a table of grade cutoffs and use a lookup formula. With…
- Find Greater Than in Excel: Formulas, Filters, and RulesTo find values greater than a number in Excel, use the greater-than operator > in a formula, or choose a greater-than condition…
- First Quartile in Excel: Find It With a Simple FormulaTo find the first quartile (Q1) in Excel, use =QUARTILE.INC(A2:A9,1) when your numeric data is in A2:A9. The formula returns the value…
- Find Duplicates in Excel with COUNTIFTo find repeated values in Excel, enter a COUNTIF formula beside your list and fill it down: with the values in A2:A20,…
- Find Common Names in Excel with Formulas and FormattingTo find names that appear in two Excel lists, use COUNTIF to check whether each name in the first list occurs in…
- Average Value in Excel: Formula, Steps, and Practical TipsTo find an average in Excel, use the AVERAGE function. With the numbers 12, 15, 18, 20, and 25 in cells B2:B6,…
- Find the Average in Excel with the AVERAGE FunctionTo find the average in Excel, enter =AVERAGE(B2:B6) in an empty cell and press Enter, replacing B2:B6 with the cells containing your…
- How to Find the Average Date in Excel With a FormulaIf your dates are in A2:A10, enter =AVERAGE(A2:A10) in an empty cell, then format that cell as a date. Excel stores valid…
- How to Filter Words in Excel: Text Filters Made ClearTo filter words in Excel, select a cell in your data, choose Data > Filter, open the arrow in the text column’s…
- How to Filter Two Columns in ExcelTo filter two columns in Excel, turn on AutoFilter for your data, then choose a filter in the first column and another…
- How to Filter Within a Filter in ExcelTo filter within an existing Excel filter, leave the first filter in place and apply another filter from a different column’s drop-down;…
- How to Filter Data in Excel: Sort and Show Key RowsTo filter data in Excel, click a cell in your list, choose Data > Filter, then use the arrow in a column…
- How to Filter Subtotals in Excel by Group or TotalTo show subtotal rows without their detail rows, use the outline buttons Excel creates with Data > Subtotal, then click outline level…