Formulas & functions
How a function works, with worked examples you can paste.
- COUNTIF Formula for Duplicates in Excel: Find and FlagTo flag every value that appears more than once in Excel, enter =COUNTIF($A$2:$A$100,A2)>1 in a helper column beside your data, then fill…
- Inventory Spreadsheet Software: How to Choose the Right ToolInventory spreadsheet software is a spreadsheet app—such as Microsoft Excel or Google Sheets—used to record stock, movements, locations, and reorder needs. It…
- VLOOKUP Between Two Sheets in Excel: How It WorksTo use VLOOKUP between two sheets in Excel, put the lookup value in one sheet and refer to the data range on…
- Index Match Across Two Sheets in Excel: A Practical GuideYes. In Excel, INDEX and MATCH can look up a value on one worksheet and return a related value from another. If…
- COUNTIF for X in a Cell: Exact or Partial MatchTo count cells whose entire value is x, use =COUNTIF(A2:A8,"x"); to count cells that contain x anywhere, use =COUNTIF(A2:A8,"*x*"). If you mean…
- Abby Lawson Budget Spreadsheet: Find the Right FileIf you’re looking for an Abby Lawson budget spreadsheet, the name alone does not identify a confirmed official download. Before using a…
- How to Paste a Formula in Excel and Keep It WorkingTo paste a formula in Excel, select the cell that contains it, press Ctrl+C, select the destination cell, and press Ctrl+V. Excel…
- XLOOKUP Formula in Excel: A Practical Step-by-Step GuideIn Excel for Microsoft 365, XLOOKUP finds a value in one range and returns the corresponding value from another: enter =XLOOKUP(E2,A2:A6,B2:B6,"Code not…
- XLOOKUP in Excel: Syntax, Examples, and TipsXLOOKUP is an Excel function that searches one range for a value and returns the corresponding value from another range. In Microsoft…
- XLOOKUP in Excel 2016: Why It Fails and What to UseXLOOKUP does not work in the standalone desktop version of Excel 2016 because that version does not include the function. Check which…
- XLOOKUP in Excel: Find a Value and Return Matching DataTo find a value in Excel and return its matching result, use XLOOKUP: with product IDs in A2:A6, product names in B2:B6,…
- Working Hours Calculation Formula in Excel: ExamplesFor a shift that starts in A2 and ends in B2 on the same day, calculate working hours with =(B2-A2)*24. If C2…
- Working Hours Calculator in Excel: Formulas and ExamplesTo calculate a shift in decimal hours, enter the start time in A2, end time in B2, and unpaid break length in…
- What Column Number Is H in Excel? Column Index ExplainedIn Excel, column H is column number 8. The letters A through H count upward from 1, so H is the eighth…
- VLOOKUP to Find Duplicates in Two Worksheets in ExcelTo find values shared by two worksheets, enter a VLOOKUP formula beside the values on the first sheet and use an exact…
- VLOOKUP in Excel: A Step-by-Step ExampleTo use VLOOKUP in Excel, put the value you want to find in a cell, select a table whose leftmost column contains…
- VLOOKUP in Excel Explained: Syntax, Examples, and LimitsVLOOKUP in Excel searches for a value in the first column of a table and returns a related value from a column…
- VLOOKUP Formula in Excel to Find DuplicatesTo check whether a value in one Excel list also appears in another, use an exact-match VLOOKUP wrapped in ISNA: =IF(ISNA(VLOOKUP(D2,$A$2:$A$100,1,FALSE)),"Not found","Duplicate").…
- VLOOKUP in Excel Data Validation Lists: How It WorksVLOOKUP can help create a dependent drop-down list in Excel, but it cannot return a list of cells by itself: it returns…
- VLOOKUP Formula Examples in Excel: Exact and ApproximateIn Excel, VLOOKUP searches the first column of a range and returns a value from another column in the same row. For…
- WORKDAY in Excel: Calculate Business Days and DatesUse Excel’s WORKDAY function to calculate a date a chosen number of working days before or after a start date, excluding weekends…
- How to Use VLOOKUP Between Two Worksheets in ExcelTo use VLOOKUP between two sheets in Excel, enter a formula on the sheet where you want the answer and point its…
- Weighted Average in Excel: Formula, Steps and ExamplesWith values in B2:B4 and their corresponding weights in C2:C4, calculate a weighted average in Excel with =SUMPRODUCT(B2:B4,C2:C4)/SUM(C2:C4). SUMPRODUCT multiplies each value…
- Using Transpose in Excel: Methods, Formulas, and TipsTo transpose data in Excel, copy the cells, select the destination, and choose Home > Paste > Transpose. For a result that…
- Excel OFFSET Function: How It Works and When to Use ItIn Excel, use OFFSET to refer to a cell or range a chosen number of rows and columns away from a starting…
- WORKDAY Function in Excel: Dates, Holidays and ExamplesUse Excel’s WORKDAY function to return a date a specified number of working days before or after a starting date. With a…
- Excel TODAY Formula: Show Today’s Date AutomaticallyTo show today’s date in an Excel cell and have it update, enter =TODAY(). The function returns the current date from Excel’s…
- Using the IFS Function in Excel: Syntax and ExamplesIn Excel, use IFS to test conditions in order and return the result paired with the first condition that is TRUE. Add…
- How to Sort in Excel: Steps, Sort Options, and FixesTo sort data in Excel, select a cell in the list, open Data > Sort, choose the column and order, then select…
- Using SUMPRODUCT in Excel: Formulas, Examples, and Common UsesIn Excel for Microsoft 365 on Windows, SUMPRODUCT multiplies corresponding values in arrays and adds the products. If quantities are in B2:B5…