Formulas & functions
How a function works, with worked examples you can paste.
- Excel XLOOKUP With Wildcards: Examples and TipsTo find a value when you know only part of the text, use XLOOKUP with wildcard match mode 2—for example, with product…
- Excel XLOOKUP Sort Order: How Search Direction WorksIn Excel, XLOOKUP does not have a separate sort-order argument: its sixth argument, search_mode, controls the direction or method of searching. The…
- Excel XLOOKUP Search Mode: Options, Rules, and ExamplesIn Excel, XLOOKUP’s search_mode argument controls whether the function searches from first to last, last to first, or uses a binary search…
- Excel XLOOKUP Between Dates: Find a Date RangeTo find the value tied to the most recent start date on or before a date, use XLOOKUP with match mode -1.…
- Excel XLOOKUP Between Two Dates: Formula and ExamplesTo use XLOOKUP for a date that falls between a start date and an end date, test both date columns and look…
- Excel Working Hours Formula: Calculate Time WorkedIf A2 contains a shift start time and B2 its end time on the same day, enter =(B2-A2)*24 to calculate hours as…
- Excel Workdays Between Dates: Formulas and ExamplesTo count workdays between two dates in Excel, use NETWORKDAYS. With the start date in A2 and the end date in B2,…
- Excel Workday Difference Between Two DatesIn Excel for Microsoft 365 on Windows, use =NETWORKDAYS(A2,B2) to count working days from the start date in A2 through the end…
- Excel Weighted Average Using SUMPRODUCT: Formula and ExamplesTo calculate a weighted average in Excel, multiply each value by its weight, add those products, then divide by the sum of…
- Excel Wildcard XLOOKUP: Find Partial MatchesYes. In Microsoft Excel for Microsoft 365, XLOOKUP can find a partial text match when you set its match mode to 2…
- Excel WEEKDAY vs WORKDAY: What Each Function Does in ExcelExcel’s WEEKDAY function tells you which day of the week a date falls on, as a number; WORKDAY returns a date a…
- Excel Weekdays Between Dates: Formulas, Holidays, and TipsTo count weekdays between two dates in Excel, use =NETWORKDAYS(A2,B2), with the start date in A2 and the end date in B2.…
- Excel Week Number: Formulas, ISO Weeks, and Dates ExplainedIn Excel, use WEEKNUM to return a date’s week number; for the internationally standardized Monday-starting system, use ISOWEEKNUM. The result depends on…
- Excel VLOOKUP With Two Criteria: Formula and ExamplesYes. To use VLOOKUP with two criteria, combine the criteria into one helper key, then look up that key with an exact…
- Excel VLOOKUP Using Two Sheets: Steps and ExamplesTo use VLOOKUP across two sheets in the same Excel workbook, enter a formula that names the source sheet in its table…
- Excel VLOOKUP IFERROR: Return a Blank for Lookup ErrorsTo make an Excel VLOOKUP display a blank when it returns an error, wrap it in IFERROR: =IFERROR(VLOOKUP(E2,$A$2:$C$100,3,FALSE),""). With the lookup value…
- Excel VLOOKUP With Multiple Criteria: Examples and TipsYes—VLOOKUP can look up a row using multiple criteria if you combine those criteria into one lookup key. For example, if the…
- Excel VLOOKUP Between Two Dates: Find the Matching RangeTo use VLOOKUP for a date that falls between a start date and an end date, sort the start dates from oldest…
- Excel VLOOKUP Between Dates: Find the Matching RangeTo use VLOOKUP between dates, put each date range’s starting date in the first column, sort those dates from oldest to newest,…
- Excel Value Comparison Formula: Examples and OptionsIn Excel, compare two values with =A2=B2: it returns TRUE when the values match and FALSE when they do not. To test…
- Excel Table Names in Formulas: How to Use Them WellYes. In Excel for Microsoft 365 on Windows, use a table name and its column header in a structured reference, such as…
- Excel SUMIFS With Multiple Criteria: A Practical GuideWith sales in D2:D7, regions in B2:B7, and products in C2:C7, use =SUMIFS(D2:D7,B2:B7,"East",C2:C7,"Tea") to add sales where the region is East and…
- Excel Named Ranges in Formulas: How to Use ThemYes. Excel lets you use a named range in a formula just like a cell reference: if the name Sales refers to…
- Excel COUNTIFS: How to Count Rows With OR ConditionsCOUNTIFS uses AND logic between its criteria pairs: a row must meet every condition you give it. To count rows that meet…
- Excel Unique List Without Duplicates: How to Make OneTo make a unique list in Microsoft Excel for Microsoft 365 on Windows, enter =UNIQUE(A2:A100) in an empty cell, replacing the range…
- Excel Unique Values Without Duplicates: Methods That WorkTo show each value once in Excel, use the UNIQUE function: with a list in A2:A7 containing Apple, Pear, Apple, Plum, Pear,…
- Excel UNIQUE Function: Return Values Without DuplicatesYes. In Microsoft 365 for Windows, enter =UNIQUE(A2:A100) to return the distinct values in A2:A100, with repeated entries appearing only once. The…
- Excel Transpose Bottom to Top: Formulas and Fixes GuideTo transpose a vertical list from bottom to top into a horizontal row in Excel for Microsoft 365, enter =TRANSPOSE(SORTBY(A2:A10,ROW(A2:A10),-1)) in an…
- Excel Top N Formula: Find the Highest Values and RowsTo return the top N numbers in Excel for Microsoft 365, use =LARGE(B2:B20,SEQUENCE(3)) to spill the three largest values from B2:B20. To…
- Excel TEXT Formula for Dates: Format Dates ClearlyIf A2 contains a real Excel date, use =TEXT(A2,"mmmm d, yyyy") to display it as text such as July 4, 2026. Replace…