Formulas & functions
How a function works, with worked examples you can paste.
- How to Group Names in Excel: Sort, Count, or CollapseTo group names in Excel, sort the list by the name or category column; to make rows collapsible, select adjacent rows and…
- How to Filter in Excel and Find the Exact Rows You NeedTo filter a list in Excel, select a cell in your data, choose Data > Filter, then open a column’s drop-down arrow…
- How to Get a Sequence Number in Excel AutomaticallyTo create a simple sequence number in Excel, enter a formula in the first numbering cell and fill it down. For example,…
- How to Get the Highest Number in Excel with the MAX FunctionTo get the highest number in a range, use Excel’s MAX function. With sample values in A2:A8, enter =MAX(A2:A8) in an empty…
- Excel Paste Options: Find, Choose, and Use the Right OneTo get Paste Options in Excel, copy a cell or range, select the destination, and paste with Ctrl+V; then click the small…
- Paste Values in Excel: Keep Results, Remove FormulasTo get paste values in Excel, copy the cells, select where the results should go, then choose Home > Paste > Values.…
- How to Get a Drop-Down Filter in ExcelTo get drop-down filter arrows in Excel, select a cell in your data range, then choose Data > Filter. Excel adds an…
- How to Get the Filter Option in Excel and Use It EasilyTo get the Filter option in Excel, click a cell in your data and select Data > Filter. Excel adds a drop-down…
- How to Get Out of Filter Mode in Excel and Show All RowsTo get out of filter mode in Excel and show every row, select a cell in the filtered data and choose Data…
- How to Sort Dates Correctly in Excel Without ErrorsTo sort dates correctly in Excel, make sure Excel recognizes the entries as real dates, then select a cell in the data…
- How to Get the Average Number in Excel with a FormulaTo get the average number in Excel, enter =AVERAGE(B2:B10) in an empty cell, replacing B2:B10 with the range that contains your numbers,…
- Round Up in Excel: Use ROUNDUP for Any Number or DecimalTo round a value in Excel away from zero, use =ROUNDUP(A2,0) when the number is in cell A2 and you want a…
- Freeze Values in Excel: Turn Formulas Into Fixed ResultsTo freeze values in Excel, select the formula cells, copy them, then choose Home > Paste > Paste Values to replace the…
- Freeze Numbers in Excel: Keep Formula Results FixedTo freeze a number produced by a formula in Excel, copy the cell or range, then paste it back as values: select…
- Freeze a Formula in Excel: Keep Cell References FixedTo freeze a cell reference while copying a formula in Excel, edit the formula, select the reference, and press F4 to add…
- Freeze Function in Excel: Freeze Panes or FormulasTo keep headings visible while you scroll, select the cell just below and to the right of the rows and columns you…
- How to Format Proper Names in Excel with PROPER FunctionTo capitalize names in Excel, put this formula in a blank helper column beside the first name: =PROPER(A2). This assumes the original…
- Number Sequence in Excel: How to Continue a SeriesTo continue a number sequence in Excel, enter the first two values, select both cells, then drag the fill handle down or…
- How to Forecast Dates in Excel with Useful FormulasTo extend a regular date schedule, add the interval to the previous date—for example, with a date in A2, enter =A2+7 in…
- Find Years of Service in Excel with a Simple FormulaTo calculate completed years of service in Excel, put each employee’s hire date in B2 and enter =DATEDIF(B2,TODAY(),"y") in C2. The result…
- How to Find a Z Value in Excel: Formulas and ExamplesTo calculate a z-score for a value in Excel, subtract the dataset mean from the value and divide by the standard deviation;…
- How to Find XLOOKUP in Excel and Use It in a FormulaTo find XLOOKUP in Excel for Microsoft 365 on Windows, open the Formulas tab and choose Lookup & Reference, then select XLOOKUP.…
- How to Find a Weighted Average in Excel with SUMPRODUCTTo find a weighted average in Excel, multiply each value by its weight, add those products, then divide by the total weight.…
- Find Unique Names in Excel: 3 Reliable MethodsTo find a list of distinct names in Excel, enter =UNIQUE(A2:A100) in an empty cell if you use Microsoft 365 or Excel…
- How to Find Variance in Excel: Formulas and ExamplesTo find variance in Excel, enter =VAR.S(B2:B6) for a sample or =VAR.P(B2:B6) for an entire population, replacing the range with your data.…
- How to Find the Sum of a Column in Excel With a FormulaTo find the sum of a column in Excel, enter a SUM formula such as =SUM(A2:A20) in an empty cell; if your…
- How to Find Standard Deviation in Excel With FormulasTo find standard deviation in Excel, enter =STDEV.S(B2:B9) for a sample or =STDEV.P(B2:B9) for an entire population, replacing B2:B9 with your data…
- Q1 and Q3 in Excel: A Formula for Finding QuartilesTo find the first and third quartiles in Excel, use QUARTILE.INC with quartile numbers 1 and 3. If your numeric data is…
- Find a Position in Excel with MATCH and XMATCH FormulasTo find where a value sits within a list, use MATCH or XMATCH. If the value to find is in E2 and…
- Percentage Difference in Excel: Formula and ExamplesTo find percentage difference in Excel, divide the absolute difference between two values by their average, then format the result as a…