Excel formula examples

This webpage contains a list of formula examples sorted in categories, the left sidebar shows the category names.

1475. Bifid

1476. Trifid

_____Update list with new values if possible

1477. Modify Scroll Bar settings

_____Macro deletes entire row if the formula returns blanks

1478. How to use the IF function

1479. What happens if a text string is used in the logical expression?

_____How to check if a cell is blank?

_____How to check if a cell is not blank?

_____How to check if a cell contains an error?

1480. How to check if a cell is a text value?

1481. How to check if a cell is a number?

1482. if false do nothing?

1483. IF function - greater than

1484. IF function - smaller than

_____IF function - equals

_____IF function - equals multiple values

1485. IF function - does not equal

1486. IF function - begins with

1487. IF function - ends with

1488. IF function - contains

1489. IF function - contains any text

_____IF function - exact match case sensitive

1490. IF function - AND OR

1491. IF function between two sheets?

1492. IF function - copy cell value?

1493. IF function - add value?

1494. IF function - keep value?

_____IF function - keep blank?

1495. If function based on cell color?

1496. How to work with multiple values in the IF function? (arrays)

1497. IF function - between two numbers?

1498. How to use nested IF functions

1499. IF with OR function

1500. Check if there is at least one number above a given value

_____How to check if there is a blank value in a cell range

_____What if I don't have the lookup column in the left-most column?

_____Extract unique distinct values if adjacent cell is text

1501. Match if cell contains string [Array Formula]

_____Filter records based on a date range and if a cell value contains a string

_____Extract records where all criteria match if not empty

_____Extract unique distinct values if the value contains the given string

_____Extract unique distinct values if the value contains the given string - Excel 365

_____Extract unique distinct values if the value contains the given string - earlier Excel versions

1502. How to return a value if lookup value is in a range

1503. If value in range then return value - LOOKUP function

1504. If value in range then return value - VLOOKUP function

1505. If value in range then return value - INDEX + MATCH

1506. Return multiple values if in range

1507. VLOOKUP and return multiple values - if not equal to

1508. VLOOKUP and return multiple values - if smaller than

1509. VLOOKUP and return multiple values - if larger than

1510. VLOOKUP and return multiple values - if contains

1511. VLOOKUP and return multiple values - if not contain

1512. How many unique distinct products did Jennifer sell in January and in region South?

Ifs

1513. How to use the MINIFS function

1514. MINIFS function example

1515. MINIFS Function not working

_____MINIFS function multiple criteria ex 1

_____MINIFS function multiple criteria ex 2

1516. MINIFS function greater than 0 (zero)

_____MINIFS function date

_____MINIFS function not blank

1517. How to use the IFS function

1518. IFS function example

_____IFS function alternative

1519. IFS function - convert month number to month name

1520. How to use the MAXIFS function

1521. MAXIFS function example

_____MAXIFS function - criteria

1522. MAXIFS function - smaller than

1523. Can you use other functions in the MAXIFS function?

1524. Can you perform calculations in the MAXIFS function?

_____How to use the AVERAGEIFS function

_____AVERAGEIFS function not working

_____AVERAGEIFS Function example

_____AVERAGEIFS function - wildcard characters

_____AVERAGEIFS Function - begins with

_____AVERAGEIFS Function - ends with

_____AVERAGEIFS Function - contains

_____AVERAGEIFS function - nested functions and arrays

1525. How to use the SUMIFS function

1526. SUMIFS function greater than

1527. SUMIFS function not equal

_____SUMIFS function multiple criteria

1528. SUMIFS function or

1529. SUMIFS Function example using partial match

1530. How to use logical operators in the SUMIFS function

_____How to merge data using two or more criteria with the COUNTIFS function

_____How to use the COUNTIFS function

_____COUNTIFS function example

_____COUNTIFS function - Partial match using wildcard characters

_____COUNTIFS function - using two conditions

_____COUNTIFS function - Logical operators

_____COUNTIFS function - Count duplicate records

_____COUNTIFS function - return an array identifying records based on multiple conditions

_____COUNTIFS function - OR logic

_____COUNTIFS function - how to use dates

_____COUNTIFS function - after a date

_____COUNTIFS function - before a date

_____How to make the COUNTIFS function work with a dynamic range

_____Highlight unique rows (COUNTIFS function)

Ignore, avoid, prevent, exclude, hide

_____DROP Function example - exclude columns

_____DROP Function example - exclude columns and rows

_____MAX function ignore #N/A error

1531. What values are excluded from the calculation?

1532. Which values are excluded in the calculation?

1533. What will the function not exclude?

1534. Does the EXACT function ignore cell formatting?

1535. MIN function ignore 0 (zero)

_____MIN function ignore errors

1536. MIN function ignore negative numbers

1537. MIN function ignore text

_____MIN function ignore #NA error

_____Are boolean values ignored in the AVERAGE function?

_____How to exclude some cells from average

_____AVERAGE ignore blanks

_____AVERAGE ignore NA()

_____Does the SUBTOTAL function avoid double counting?

1538. How to exclude manually hidden values from the SUBTOTAL function?

_____Hashtag character lets you hide extra zeros

1539. How to hide specific values - TEXT function

1540. How to hide positive numbers

1541. How to hide negative numbers

1542. How to hide zeros

1543. How to hide text values

_____How to sum a column and ignore errors?

1544. Show / hide a picture using a button

_____Wildcard lookups and include or exclude criteria

_____Wildcard lookups and include or exclude criteria - Excel 365

_____Wildcard lookups and include or exclude criteria - array formula

_____Wildcard lookups and include or exclude criteria - autofilter

1545. Prevent duplicate records in a worksheet

1546. Hide values in cell F2:G2

_____How to ignore error values using the SMALL function

1547. How to ignore zeros using the SMALL function

_____SMALL function ignore duplicates

_____Ignore duplicates [Excel 2019]

_____Ignore duplicates [Excel 365]

_____Count digits and ignore duplicates

_____Extract a unique distinct list and ignore blanks

_____Extract a unique distinct list and ignore blanks (Excel 365)

_____Extract a unique distinct list sorted from A to Z and ignore blanks - earlier Excel versions

_____How to hide duplicate values [Conditional Formatting]

_____How to ignore blank cells

_____Extract unique distinct values A to Z from a range and ignore blanks - Excel 365

_____Extract unique distinct values A to Z from a range and ignore blanks

Image, picture

1548. How to use the IMAGE function

_____Show an image based on a drop-down list

1549. IMAGE function not working

_____Show / hide a picture using a button

1550. Insert an image

1551. Place image next to the upper-right corner of shape

1552. Place image next to the upper-left corner of shape

1553. Place image next to the lower-left corner of shape

1554. Heat map using pictures

Index

1555. Example 1 - INDEX function

1556. Horizontal and vertical lookup - INDEX + MATCH

1557. How to use the INDEX function

1558. How to create array constants in the INDEX function

_____How to return all values in a row or column in a given cell range with the INDEX function

1559. How to use the [area_num] argument - INDEX function

1560. How to return the entire row in a given cell range using the INDEX function

_____How to return an column of values in a given cell range using the INDEX function

1561. How to return the entire specified cell range - INDEX function

_____How to build a dynamic cell reference using the INDEX function

1562. Can you replace the VLOOKUP function with the INDEX function?

1563. Where do I use the INDEX - MATCH functions instead of VLOOKUP?

1564. Two index table

1565. If value in range then return value - INDEX + SUMPRODUCT + ROW

_____If value in range then return value - INDEX + MATCH

Index match, index and match

1566. INDEX MATCH – multiple results

1567. INDEX MATCH - multiple results

_____INDEX and MATCH - multiple criteria and multiple results

_____INDEX and MATCH - multiple criteria and multiple results (Excel 365)

_____How to do a case sensitive INDEX MATCH - array formula

_____How to do a case sensitive INDEX MATCH - regular formula

_____How to do a case sensitive partial match using INDEX and MATCH functions

_____INDEX MATCH - multiple criteria

_____INDEX MATCH - partial text multiple conditions Excel 365

_____INDEX MATCH - partial match multiple columns

_____INDEX MATCH - Last value

1568. VLOOKUP vs INDEX MATCH

_____Merge data using the INDEX and MATCH functions

1569. SMALL function – INDEX MATCH

_____SMALL function – INDEX MATCH - Excel 365

Intersection

1570. Calculate the intersection of two cell ranges

Lambda

1571. How to use the LAMBDA function

_____Substitute multiple text strings - Excel 365 recursive LAMBDA function

1572. Workaround for the TEXTSPLIT function - LAMBDA function

_____Filter unique rows case sensitive - Excel 365 LAMBDA function

_____Filter unique distinct rows case sensitive - Excel 365 recursive LAMBDA function

_____Fuzzy VLOOKUP - Excel 365 LAMBDA function

_____Fuzzy lookups - Excel 365 recursive LAMBDA function

_____Filter words containing a given string in a cell range - Excel 365 LAMBDA function

Large, larger, highest, greater

_____Example 2 - aggregate by category and sort from large to small

_____How to convert large decimal numbers to binary?

_____Hour value larger than 24

1573. Minutes value larger than 59

1574. Seconds value larger than 59

1575. How to sort from smallest to largest?

1576. How to sort from largest to smallest?

1577. Sum numbers based on items and return totals sorted from large to small

_____Filter values if larger than

_____MINIFS function greater than 0 (zero)

_____Get the smallest number larger than a given number and a condition

_____Get the smallest number larger than a given number and criteria

1578. SWITCH Function - how to use logical operators like larger than and smaller than

_____Get largest number based on a condition

_____Get largest number based on multiple conditions

1579. MAX function second highest

_____MAX function second-highest number no duplicates

_____MAX function second-highest number based on a condition

_____Get the highest number within each row

1580. Sort rows by their highest number within each row

_____Get the highest number within each column

_____Sort columns by their highest number within each row

_____How to extract the largest number ignoring error values

_____How to extract the largest number ignoring error values using arrays

1581. How to use the LARGE function

1582. LARGE function - example

_____LARGE function - based on a condition

_____LARGE function - based on criteria

_____LARGE function - based on a list

1583. LARGE function - multiple source ranges

1584. LARGE function - based on a textstring

_____LARGE function - calculate an average based on the three largest numbers

_____How to extract the k-th largest number in a 3D range

1585. Find smallest and largest unique number

_____AVERAGEIF function - larger than

_____How to extract the largest number ignoring error values

_____Hour value larger than 24

_____Minutes value larger than 59

_____Seconds value larger than 59

_____SUMIFS function greater than

1586. SUMPRODUCT if greater than 0 (zero)

_____How to extract the largest number from filtered data?

_____How to sum if a number is larger than a given condition

1587. How to sum values greater than smaller than?

_____Find and return the highest number and corresponding date based on a condition

_____Find the largest value in lookup_vector that is less than or equal to lookup_value

1588. MOD function won't work with really large numbers?

_____Find the smallest number in a list that is larger than a given number

_____IF function - greater than

_____Example 2 - Count cells larger/less than a criterion

1589. Partial match and return value with highest level

_____VLOOKUP and return multiple values - if larger than

_____Get the largest/smallest number

_____Get the column header name that contains the largest/smallest value

_____Get the cell address of the largest/smallest number

_____Create a link to the largest/smallest number

_____How to highlight the largest and smallest value

Letter

1590. Example 12 - sequence of letters

1591. Does the SORTBY function differentiate between upper and lower letters?

_____How to sort by the first letter/digit?

_____How to sort by the first letter - Example 2

1592. How can I sort letters and numbers?

_____How to convert a column number to a column letter?

_____How to convert a column letter to a column number?

_____Extract column letter - Excel 365

_____Convert column number to column letter

_____Convert column letter to column number

_____Change upper letter to lower letter for the position of a given character

1593. Change a given upper letter to a letter

_____Change all upper letters to lower letters for a given character

_____Convert every other letter to upper or lower case

1594. Substitute all letters with a given string

_____How to change lower letter to upper letter for the position of a given character

_____How to change lower letter to upper letter for a given character

_____How to change all lower letters to upper letters for a given character

_____Extract the last letter

1595. Convert letters to numbers

Lookup, find, identify

_____Two-way lookup using multiple tables

_____Partial match VLOOKUP - asterisk character (wildcard)

1596. How to use the XLOOKUP function

1597. XLOOKUP function - example

1598. How to perform a binary xlookup

1599. How to perform a wildcard xlookup

_____Lookup and return multiple sorted values based on corresponding values in another column - Excel 365

_____Lookup and return multiple sorted values based on corresponding values in another column - previous Excel versions

_____Lookup and return multiple sorted values based on corresponding values in another column - Excel Table

1600. Find and replace strings in file names, folder name and subfolders

1601. How to use the FIND function

1602. FIND Function example

1603. FIND Function not working

1604. FIND function returns all positions of a given substring

1605. Find the element name based on an atomic number

1606. Find the optimal permutation - Excel Solver

_____Find smallest and largest unique number

1607. CELL function - How to find out which formatting a specific cell has

_____How to identify a new line character in an Excel formula

_____Column function and VLOOKUP

1608. Identify numbers stored as text

_____Identify digits in a string

1609. MID function with FIND function

1610. CHOOSE function with VLOOKUP

_____Find the last non-empty cell with short cut keys

1611. Locate lookup values in an Excel table

1612. How to use the HLOOKUP function

1613. HLOOKUP function - Overview

1614. Video - HLOOKUP function

1615. Horizontal and vertical lookup

_____Horizontal and vertical lookup - INDEX + MATCH

1616. HLOOKUP - multiple tables

1617. How to use the VLOOKUP function

1618. VLOOKUP function formula

1619. VLOOKUP - approximate match

_____Merge two data sets using the VLOOKUP function

1620. VLOOKUP - how to use multiple tables

_____VLOOKUP - What if the lookup value is not in the leftmost column?

_____How to handle VLOOKUP errors

_____Using multiple criteria in VLOOKUP

1621. VLOOKUP function - Partial match using wildcards

1622. VLOOKUP function - Partial match - begins with

1623. VLOOKUP function - Partial match - ends with

1624. VLOOKUP function - Partial match - contains

1625. VLOOKUP function - Partial match - question mark

_____VLOOKUP function - tilde character escapes wildcard characters

1626. VLOOKUP - Duplicate repeated values

_____VLOOKUP and HLOOKUP together

1627. VLOOKUP - can't find a value that is there

_____VLOOKUP alternatives

1628. VLOOKUP just shows the formula

1629. VLOOKUP another sheet

1630. VLOOKUP keep formatting

1631. VLOOKUP backward - lookup from bottom to top

_____VLOOKUP on two columns

_____VLOOKUP between dates

_____VLOOKUP returns #N/A

_____VLOOKUP yes if true

1632. VLOOKUP part of text

_____VLOOKUP vs INDEX MATCH

_____VLOOKUP returns multiple columns

_____VLOOKUP zero if not found

1633. VLOOKUP sum

1634. VLOOKUP true false

1635. VLOOKUP unique

_____Use VLOOKUP to calculate discounts, commissions, tariffs, charges, shipping costs, packaging expenses or bonuses

_____How to perform two-way lookup in multiple tables - 2D

1636. How to quickly find an Excel Table in a workbook

1637. Identify missing numbers in a range

_____Find and return the highest number and corresponding date based on a condition

_____Lookup value based on two critera – second criteria is the adjacent value and its position in a given list

1638. How to identify array formulas?

_____Find most overlapped date range

_____Find empty dates in a set of date ranges

1639. Find numbers closest to sum

_____Find numbers closest to sum - Excel 365

_____Find numbers in total with a condition

_____Find numbers in total with a condition - Excel 365

1640. How to use the LOOKUP function

1641. Be careful with the LOOKUP function

_____Find the largest value in lookup_vector that is less than or equal to lookup_value

1642. How to use multiple values in the LOOKUP function

_____How to make the LOOKUP function work with multiple worksheets

1643. Nested LOOKUP functions

1644. How to lookup multiple values simultaneously (array formula)

_____Find last matching value in an unsorted list

_____Lookup and match last value - reverse lookup

1645. How to VLOOKUP using the INDIRECT function?

1646. Lookup for a multi-level sequence

1647. Lookup for multiple multi-level sequences

1648. How to find two search values next to each other vertically?

1649. How to find all instances of two search values next to each other vertically?

1650. How to find a sequence with any value between?

1651. Find multiple sequences with any value between?

1652. A quicker A * pathfinding algorithm

1653. Finding the shortest path – A * pathfinding

_____How to join data sets using the VLOOKUP function

1654. Identify rows of overlapping records

_____Identify rows of overlapping records - Excel 365

1655. Identify rows of overlapping records - earlier versions

_____Identify overlapping date ranges

_____Find earliest and latest overlapping dates in a set of date ranges based on a condition

_____Wildcard lookups and include or exclude criteria

_____Wildcard lookups and include or exclude criteria - Excel 365

_____Wildcard lookups and include or exclude criteria - array formula

_____Wildcard lookups and include or exclude criteria - autofilter

_____Lookup with any number of criteria

_____Lookup with an unknown number of criteria - Array Formula

_____Lookup with an unknown number of criteria - Advanced Filter

_____Find entry based on conditions

_____Lookup multiple values in one cell - Excel 365

_____How can I find all errors in a worksheet?

_____IFERROR function simplifies finding errors in formulas

_____Find all sequences of consecutive dates

_____Find all sequences of consecutive dates - Excel 365

_____Find all sequences of consecutive dates - earlier Excel versions

_____Find empty cells and sum cells above

_____Find the smallest number in a list that is larger than a given number

_____COUNTIFS function - return an array identifying records based on multiple conditions

1656. Lookup_array in ascending order

1657. Lookup_array in any order

1658. Lookup_array in descending order

_____Can you replace the VLOOKUP function with the INDEX function?

_____Where do I use the INDEX - MATCH functions instead of VLOOKUP?

_____Find date range based on a date

_____How to use VLOOKUP/XLOOKUP with multiple conditions

_____VLOOKUP function with two conditions applied to two columns (AND logic)?

_____VLOOKUP function with two conditions applied to two columns (OR logic)?

_____VLOOKUP function with many conditions applied to one column (OR logic)?

1659. Can we use VLOOKUP with multiple lookup values?

_____VLOOKUP across multiple columns?

_____Can you concatenate VLOOKUP results?

_____How to use VLOOKUP with dates?

_____What if I don't have the lookup column in the left-most column?

_____VLOOKUP - Select column using a drop-down list

_____VLOOKUP in a filtered Excel Table and return multiple values

_____XLOOKUP - two conditions in two columns (AND logic)?

_____XLOOKUP - two conditions in two columns (OR logic)?

_____XLOOKUP - multiple conditions in one column (OR logic)?

1660. Can we use XLOOKUP with multiple lookup values?

_____XLOOKUP across multiple columns?

_____Can you concatenate XLOOKUP results?

_____How to use XLOOKUP with dates?

_____What if I don't have the lookup column in the left-most column?

_____XLOOKUP of three columns to pull a single record

_____Highlight lookups in relational tables

_____Find empty hours in a weekly schedule

_____Lookup multiple values across columns and return a single value

_____Lookup using multiple conditions

_____Lookup a date range and a condition - return multiple values

_____Lookup a date range and a condition - return multiple values - Excel 365

1661. Find numbers in close proximity to a given number

_____Highlight lookup values

1662. VLOOKUP – Return multiple unique distinct values

1663. VLOOKUP - Return multiple unique distinct values

_____VLOOKUP - Return multiple unique distinct values (Excel 365)

1664. Find lower prices

1665. Find higher prices

1666. Fuzzy VLOOKUP

_____Fuzzy VLOOKUP - Excel 365 LAMBDA function

1667. Fuzzy VLOOKUP - array formula

_____Fuzzy lookups - Excel 365 recursive LAMBDA function

_____Lookup and return multiple values concatenated into one cell

_____Lookup and return multiple values concatenated into one cell [Excel 2019]

_____Lookup and return multiple dates concatenated into one cell [Array Formula]

_____Lookup within a date range and return multiple values concatenated into one cell [Array Formula]

_____How to return a value if lookup value is in a range

_____If value in range then return value - LOOKUP function

_____If value in range then return value - VLOOKUP function

1668. Identify numbers in sum using Excel solver

1669. Find positive and negative amounts that net to zero

_____Use VLOOKUP to search date in date ranges and return value on the same row

_____Find the most recent date that meets a particular condition

_____Lookup a value and find the most recent date

_____Lookup a value and find the most recent date (Pivot Table)

_____Lookup all values and find the most recent dates

_____Lookup and find the most recent date using multiple conditions

_____Lookup and find the most recent date on multiple sheets

_____Lookup and find the most recent date, return another value on the same row

_____Find the most recent date in a list

_____Lookup the nearest date

_____Lookup min max values within a date range

1670. 5 easy ways to VLOOKUP and return multiple values

1671. VLOOKUP - Return multiple values [vertically]

_____VLOOKUP and return multiple values - case sensitive

_____VLOOKUP and return multiple values - if not equal to

_____VLOOKUP and return multiple values - if smaller than

_____VLOOKUP and return multiple values - if larger than

_____VLOOKUP and return multiple values - if contains

_____VLOOKUP and return multiple values - if not contain

1672. VLOOKUP and return multiple values - that begins with

1673. VLOOKUP and return multiple values - that ends with

_____How to count VLOOKUP results

1674. VLOOKUP - Return multiple values [horizontally]

_____VLOOKUP - Extract multiple records based on a condition

_____Lookup and return multiple values [AutoFilter]

_____Lookup and return multiple values [Advanced Filter]

1675. Lookup and return multiple values [Excel Defined Table]

_____VLOOKUP with 2 or more lookup criteria and return multiple matches

1676. Vlookup with multiple matches returns a different value

_____Lookup with multiple matches returns different values - Excel 365

_____Vlookup across multiple sheets

1677. VLOOKUP a cell range and return multiple values

_____VLOOKUP and return multiple values across columns

_____How to perform a two-dimensional lookup

_____Reverse two-way lookups in a cross reference table [Excel 2016]

_____Reverse two-way lookups in a cross reference table [All excel versions]

_____Reverse two-way lookup in a cross reference table

_____Two-dimensional lookup using two tables

_____Create a hyperlink linked to the result of a two-dimensional lookup

1678. Find missing numbers

_____Find missing numbers in a column based on a given range

_____Find missing three character alpha code numbers

_____Identify missing numbers in two columns combined based on a numerical range

_____Identify missing numbers in two columns combined based on a numerical range - Excel 365

1679. Return multiple matches with wildcard VLOOKUP

1680. How to quickly find the maximum or minimum value [Formula]

1681. Find min and max unique and duplicate numerical values

1682. Find closest value

1683. Find the closest value

_____Find closest value - Excel 365

1684. Find closest values

_____Find closest values - Excel 365

1685. Find closest values and return adjacent values

_____Find closest value with a criterion

_____How to find errors in a worksheet

_____How to find blank cells

_____Identify all characters in a cell value

_____Identify all characters in a cell value - Excel 365

Match

1686. How to use the XMATCH function

1687. XMATCH Function Comments

_____AVERAGEIF function - match a specific number of characters

_____How to do a partial case sensitive match using two conditions in two columns

_____Match two columns and return another value on the same row

_____Match two columns and return another value on the same row (array formula)

_____Match two columns and return another value on the same row (regular formula)

_____Match two columns and return another value on the same row - case sensitive

_____Display matches if cell contains text from list (Excel 2019)

_____Display matches if cell contains text from list (Earlier Excel versions)

1688. How to use an asterisk to perform a wildcard match in the SUMIF function

1689. Approximate match

_____Horizontal and vertical lookup - INDEX + MATCH

_____VLOOKUP - approximate match

_____Count matching strings using regular expressions

1690. How to match phone numbers?

_____Find last matching value in an unsorted list

_____Lookup and match last value - reverse lookup

_____IF function - exact match case sensitive

1691. How to use the MATCH function

1692. How to use the MATCH function in an array formula

_____Match cell that ends with the condition

_____Match cell that begins with the condition

1693. Match cell that contains a given string

_____Match cell that begins with a specific string and ends with another string - any number of characters in between

_____Match cell that begins with string and ends with another string - a single character in between

_____How to do a case sensitive match

_____Where do I use the INDEX - MATCH functions instead of VLOOKUP?

_____Compare two lists and filter unique values where the sum in one column doesn't match the other column

_____Match if cell contains string [Array Formula]

_____Match two criteria and return multiple records

_____Match two criteria and return multiple records [Array Formula]

_____Match two criteria and return multiple records [Excel 365]

_____Match two criteria and return multiple records [Excel defined Table]

_____Match two criteria and return multiple records [Advanced Filter]

_____Extract records where all criteria match if not empty

_____If value in range then return value - INDEX + MATCH

_____Match a range value containing both text and numerical characters

_____Formula for matching a date within a date range

_____Match a date when a date range is entered in a single cell

_____Match a date when a date range is entered in two cells sorted in ascending order

_____Match a date when a date range is entered in two cells with gaps not sorted

_____Match a date when date ranges sometimes overlap and return multiple results

_____VLOOKUP with 2 or more lookup criteria and return multiple matches

_____Vlookup with multiple matches returns a different value

_____Lookup with multiple matches returns different values - Excel 365

_____Merge matching rows

_____Return multiple matches with wildcard VLOOKUP

Max

1694. How to use the MAX function

1695. MAX function not working

1696. Max function returns 0 (zero)

1697. Max function for text

_____MAX function ignore #N/A error

_____MAX function second highest

_____MAX function second-highest number no duplicates

_____MAX function second-highest number based on a condition

_____How to use the MAXIFS function

_____MAXIFS function example

_____MAXIFS function - criteria

_____MAXIFS function - smaller than

_____Can you use other functions in the MAXIFS function?

_____Can you perform calculations in the MAXIFS function?

1698. Example 4 - MAX

1699. Change minimum and maximum value on the vertical axis

_____Lookup min max values within a date range

_____How to highlight MAX and MIN value within a month

_____How to quickly find the maximum or minimum value [Formula]

_____Find min and max unique and duplicate numerical values

Min

_____Calculate the complex determinant of a 2x2 matrix

_____Minutes value larger than 59

1700. TIME function - how to add minutes

1701. How to use the MINUTE function

_____How to use the MINIFS function

_____MINIFS function example

_____MINIFS Function not working

_____MINIFS function multiple criteria ex 1

_____MINIFS function multiple criteria ex 2

_____MINIFS function greater than 0 (zero)

_____MINIFS function date

_____MINIFS function not blank

1702. How to use the MINA function

1703. MINA Function Example 1

1704. MINA Function Example 2

1705. MINA Function not working

1706. How to use the MINVERSE function

_____How to round a date to the nearest upcoming weekday?

_____How to use the MINUTE function

1707. Example 5 - MIN

_____Minutes value larger than 59

_____TIME function - how to add minutes

1708. How to use the MIN function

1709. MIN function example

_____MIN function ignore 0 (zero)

1710. MIN function returns 0 (zero)

1711. MIN function not working

_____MIN function ignore errors

_____MIN function ignore negative numbers

_____MIN function ignore text

_____MIN function ignore #NA error

_____Use price ranges to determine discount

_____Change minimum and maximum value on the vertical axis

1712. Bill reminder in excel

_____Lookup min max values within a date range

_____How to highlight MAX and MIN value within a month

_____How to quickly find the maximum or minimum value [Formula]

_____Find min and max unique and duplicate numerical values

_____Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors

Minute

_____Minutes value larger than 59

_____TIME function - how to add minutes

_____How to use the MINUTE function

_____Minutes value larger than 59

_____TIME function - how to add minutes

Month

1713. Example 5 - aggregate by year and month

_____Count weekdays in a month

_____How to calculate a date based on specific weekday in a month

1714. Year and month

_____Year and month to date?

1715. How to use the EOMONTH function

1716. How to use the MONTH function

_____Add or subtract months and days

_____Date function add months

_____Last day of a given month

_____Calculate complete months between two dates

1717. MONTH Function not working

1718. MONTH Function example

_____MONTH function alternative

1719. MONTH function - return month name instead of a number

_____Filter dates based on month

_____How to get historical monthly stock prices

1720. Example 9 - sequence of months

1721. How to sort by month?

_____Extract unique distinct year and months from dates

_____Highlight a row if the date is in the last month

_____Highlight a row if the date is in this month

_____Highlight a row if the date is in the next month

_____How to use the EOMONTH function

_____Calculate complete months between two dates

_____IFS function - convert month number to month name

_____Count weekdays in a month

_____How to calculate a date based on specific weekday in a month

_____How to use the MONTH function

_____MONTH Function not working

_____MONTH Function example

_____MONTH function alternative

_____MONTH function - return month name instead of a number

_____Filter dates based on month

_____How do I sum values between n-th weekday this month and n-th weekday next month?

_____Count cells based on a condition and month

_____How to average by month

_____Year and month

_____Year and month to date?

_____Add or subtract months and days

_____Date function add months

_____Last day of a given month

1722. How to sum values by month?

1723. Building monthly sheets

1724. Create remaining months

1725. Create monthly time sheet using a Pivot Table

1726. Worksheet Month

_____Create date ranges that stay within month

_____Dates not in selected month

_____Remove duplicates within same month or year

_____Monthly calendar template

_____Monthly calendar template 2

_____Calendar - monthly view - Excel 365

_____Create a number sequence to count records by year and month (sorted list)

_____Create a number sequence to count records by year and month (unsorted list)

_____Create a monthly date range

_____Filter duplicates within same date, week or month

_____Count unique distinct months

_____Count unique distinct values within same week, month or year

_____Highlight duplicates with same date, week or month

_____How to highlight MAX and MIN value within a month

_____Highlight odd/even months

_____List all unique distinct rows in a given month and year

_____List all unique distinct rows in a given month and year (Excel 365)

_____List all rows in a given month and year

_____List all rows in a given month and year (Excel 365)

Multiply, multiplication, product

_____Multiply complex number by i

_____How to calculate the product of a complex number and its complex conjugate

1727. How to multiply numbers in an Excel formula

1728. How to multiply a number and cell value

1729. How to multiply cell values

1730. How to multiply multiple cell values

1731. How to multiply values using an Excel function

1732. How to multiply functions in an Excel formula

_____How to multiply boolean values - apply AND logic

1733. Multiply numbers in each row by entire cell range

1734. How to use the PRODUCT function

1735. Example 6 - PRODUCT

1736. SUMPRODUCT and IF function

1737. How to simplify IF functions in the SUMPRODUCT function

_____SUMPRODUCT if greater than 0 (zero)

_____SUMPRODUCT if between two dates

1738. SUMPRODUCT if cell contains text

1739. SUMPRODUCT if or

_____SUMPRODUCT – multiple criteria

_____SUMPRODUCT - based on a list of values

_____SUMPRODUCT - multiple conditions and a date range

_____SUMPRODUCT - multiple date ranges

1740. SUMPRODUCT - sum based on daily currency rates

1741. How to use the SUMPRODUCT function

1742. Things to know about the SUMPRODUCT function

_____How to use the SUMPRODUCT function

1743. How to use a logical expression in the SUMPRODUCT function

_____How to use multiple conditions in the SUMPRODUCT function

1744. How to use OR logic in the SUMPRODUCT function

1745. SUMPRODUCT and nested IF functions

_____SUMPRODUCT if not blank

_____SUMPRODUCT returns nothing (blank)

1746. SUMPRODUCT if not NA

_____SUMPRODUCT if not error

_____If value in range then return value - INDEX + SUMPRODUCT + ROW

Negative, minus, subtract

_____How to enter negative complex numbers in Excel

_____Add or subtract months and days

_____Date function subtract days

_____How to combine columns using negative values - Excel 365

1747. CHOOSEROWS Function example - negative values

1748. DROP Function example - negative values

1749. TAKE Function example - negative values

_____Extract records containing negative numbers

_____Extract negative values and adjacent cells (Excel Filter)

_____Random negative numbers with two decimals

_____Random negative numbers with three decimals

_____COUNT function - count negative numbers

1750. How to convert a negative number to positive numbers and vice versa?

1751. How to convert all numbers to negative numbers?

1752. Convert negative numbers to positive and calculate the sum

_____Convert negative numbers to positive and calculate the average

1753. Convert negative numbers to positive and calculate the median

_____MIN function ignore negative numbers

_____Add or subtract months and days

_____Date function subtract days

1754. How to convert negative numbers to positive numbers?

1755. How to convert positive numbers to negative numbers?

1756. How to change positive numbers to negative numbers and vice versa?

1757. Format positive, negative and zero values differently

_____How to hide negative numbers

_____Is -1 (negative number) equal to TRUE in a logical expression?

_____Find positive and negative amounts that net to zero

New line

_____How to identify a new line character in an Excel formula

1758. How to create a new line in an Excel formula

1759. How to show a new line in a cell (wrap text)

Not equal

_____Filter values if not equal to

_____AVERAGEIF function - not equal to

_____Case sensitive condition not equal to

_____SUMIFS function not equal

1760. How to sum not equal to

_____IF function - does not equal

_____VLOOKUP and return multiple values - if not equal to

Or logic

_____Filter values based on a condition per column - OR logic

_____How to filter using OR logic between columns - Autofilter and Excel tables

_____How to filter using OR logic between columns - Advanced Filter

_____How to use OR logic in the SUMPRODUCT function

_____COUNTIFS function - OR logic

_____VLOOKUP function with two conditions applied to two columns (OR logic)?

_____VLOOKUP function with many conditions applied to one column (OR logic)?

_____XLOOKUP - two conditions in two columns (OR logic)?

_____XLOOKUP - multiple conditions in one column (OR logic)?

_____Highlight records - multiple criteria - OR logic

_____Search each column for a string each and return multiple records - OR logic

_____How to unique distinct products using OR logic - Excel 365?

Overlapping

1761. How to sum overlapping time

1762. How to calculate overlapping time ranges

_____Count a given pattern in a cell value - overlapping allowed

_____Working with overlapping date ranges

_____Calculate the number of overlapping date ranges

_____Use a drop-down list to select a date range to see overlapping date ranges

_____Count overlapping days across multiple date ranges

_____Count overlapping days in multiple date ranges

_____Count overlapping days in multiple date ranges, part 2

_____Identify rows of overlapping records

_____Identify rows of overlapping records - Excel 365

_____Identify rows of overlapping records - earlier versions

_____Identify overlapping date ranges

_____Filter overlapping date ranges

_____Find earliest and latest overlapping dates in a set of date ranges based on a condition

_____Extract dates from overlapping date ranges

_____Extract dates from overlapping date ranges - Excel 365

_____Highlight overlapping date ranges using conditional formatting

_____Highlight records based on overlapping date ranges and a condition

Partial, wildcard, contain

_____Partial match VLOOKUP - asterisk character (wildcard)

_____How to create a string containing column and row delimiting characters

_____How to perform a wildcard xlookup

_____Filter values if contains

_____Filter values if not contain

_____Highlight cells containing string

_____Extract records containing negative numbers

1763. Units contained in a range that overlap another range

_____If cell contains any text

_____Check if a cell contains nonprintable characters

_____Check if a cell range contains nonprintable characters

_____Highlight cells containing nonprintable characters

_____AVERAGEIFS function - wildcard characters

_____AVERAGEIFS Function - contains

_____How to use wildcard characters in the AVERAGEIF function

_____AVERAGEIF function - contains

1764. Wildcard

_____SUMIFS Function example using partial match

_____Count cells containing text from list

_____How to average a column containing some text values

_____SUMPRODUCT if cell contains text

_____How to do a case sensitive partial match using INDEX and MATCH functions

_____How to do a partial case sensitive match using two conditions in two columns

_____INDEX MATCH - partial text multiple conditions Excel 365

_____INDEX MATCH - partial match multiple columns

_____Match two columns and return another value on the same row - partial match

_____How to count the number of cells containing numbers based on filtered data?

_____If cell contains text from list

_____Check if the cell contains text in the list

_____Display matches if cell contains text from list (Excel 2019)

_____Display matches if cell contains text from list (Earlier Excel versions)

_____Check if cell contains text in the list and return the corresponding value

_____If cell contains multiple values

_____If cell contains text

1765. OR function contains text

_____How to select a cell containing a hyperlink?

_____How to use an asterisk to perform a wildcard match in the SUMIF function

_____Sum cells containing numbers and text based on a condition

_____VLOOKUP function - Partial match using wildcards

_____VLOOKUP function - Partial match - begins with

_____VLOOKUP function - Partial match - ends with

_____VLOOKUP function - Partial match - contains

_____VLOOKUP function - Partial match - question mark

_____VLOOKUP function - tilde character escapes wildcard characters

1766. Search for a sequence of cells based on wildcard search

_____How to calculate the first row number of two cells containing search values next to each other vertically?

1767. How to calculate row numbers of two cells containing search values next to each other vertically?

1768. Wildcard search for a sequence

1769. Wildcard search for multiple sequences

_____Merge data sets based on a partial match - wildcard character

_____Wildcard lookups and include or exclude criteria

_____Wildcard lookups and include or exclude criteria - Excel 365

_____Wildcard lookups and include or exclude criteria - array formula

_____Wildcard lookups and include or exclude criteria - autofilter

_____SEARCH function - wildcard characters

_____Cell range contains numbers, text, and blanks?

_____COUNTIFS function - Partial match using wildcard characters

_____How to check if a cell contains an error?

_____IF function - contains

_____IF function - contains any text

_____Example 3 - Count cells containing a text string - partial match (wildcard)

_____How to use the COUNTIF function with multiple values - create an array of values containing the count of each value

_____Example 6 - How to count cells containing x number of characters?

_____How to do a partial match - wildcard character

_____Match cell that contains a given string

1770. Partial match and return multiple adjacent values

1771. Partial match and return multiple adjacent values corresponding to the number of matching values

_____Partial match and return multiple adjacent values

_____Partial match in multiple columns and return adjacent values

1772. Search and display all cells that contain all search strings

_____Partial match and return value with highest level

_____Highlight records containing text strings - AND Logic

_____Filter unique distinct values where adjacent cells contain search string

_____Extract unique distinct text values containing string in a range

_____Filter strings containing a given substring in a cell range

_____Filter words containing a given string in a cell range - Excel 365 LAMBDA function

_____Match if cell contains string [Array Formula]

_____Create dependent drop down lists containing unique distinct values

_____Create dependent drop down lists containing unique distinct values - Excel 365

_____Create dependent drop down lists containing unique distinct values

_____Create dependent drop down lists containing unique distinct values in multiple rows

_____Create a drop down list containing alphabetically sorted values

_____Filter records based on a date range and if a cell value contains a string

_____Extract unique distinct values if the value contains the given string

_____Extract unique distinct values if the value contains the given string - Excel 365

_____Extract unique distinct values if the value contains the given string - earlier Excel versions

_____Match a range value containing both text and numerical characters

_____VLOOKUP and return multiple values - if contains

_____VLOOKUP and return multiple values - if not contain

_____Filter duplicate values in a range that contain a given condition

_____Partial match based on two conditions in any column- both must match

_____Partial match with two conditions - one condition for each column

_____Partial match with two conditions - one for each column - Excel 365

_____Partial match with three conditions - one for each column

_____How to extract rows containing digits

_____How do I extract rows that contain a string in a data set or table?

_____How do I filter rows that contain a string using Advanced Filter?

_____How do I filter rows that contain a string using an Excel Table?

_____Partial match for multiple strings – AND logic

_____Partial match for multiple strings - AND logic - returns the first match

_____Partial match for multiple strings - AND logic - returns all matches

_____Partial match for multiple strings - AND logic - returns all matches (Excel 365)

_____Partial match for multiple strings - AND logic - returns all corresponding values

_____Return multiple matches with wildcard VLOOKUP

_____Create a unique distinct sorted list containing both numbers and text removing blanks with a condition - earlier Excel versions

_____Create a unique distinct sorted list containing both numbers and text removing blanks with a condition - Excel 365

_____Get the column header name that contains the largest/smallest value

_____Extract unique distinct text values containing string in a range - Excel 365

1773. How to select cells containing data

Permut

1774. How to use the PERMUTATIONA function

1775. PERMUTATIONA Function Example 1

_____Create a list of permutations - Excel 365

_____List permutations with repetition and how many to choose from

_____List all permutations with a condition

1776. How to use the PERMUT function

1777. PERMUT function example

_____Permutations without repetition - Excel 365 formula

_____Find the optimal permutation - Excel Solver

1778. How to create permutations

1779. Permutations with repetition

1780. Constructing a permutations array with binary values

1781. Permutations without repetition

Random

_____Extract values from given columns and return the list in random order - Excel 365

1782. CHOOSEROWS Function - values in random order

1783. DROP Function - values in random order

_____EXPAND Function - values in random order

1784. TAKE Function - values in random order

1785. TOROW Function - values in random order

1786. WRAPCOLS Function - values in random order

1787. WRAPROWS Function - values in random order

1788. Sort in random order

1789. Sort unique values in random order

_____Random numbers with a decimal

_____Random negative numbers with two decimals

_____Random negative numbers with three decimals

1790. Random names

_____Random list

1791. Create random text strings

1792. Random numbers

1793. Random text strings

_____Random date values

1794. Random time values

1795. Assign records unique random text strings

_____Calculate running average of last 10 data with random blank cells

_____Create a random playlist

_____Insert random characters

_____Insert random characters based on key

Rearrange, distribute

_____Rearrange values to the left if the cell is empty as far as possible

_____Rearrange values to fill empty cells

1796. Search values distributed horizontally and return corresponding values

_____Filter values distributed horizontally - Excel 365

1797. Rearrange values using formulas

1798. Rearrange data

_____Rearrange values in a cell range to a single column

1799. Round-robin tournament - distributes home and away rounds evenly

1800. Rearrange values

1801. Distribute values across numerical ranges

Record, row

1802. How to use the CHOOSEROWS function

1803. How to use the TOROW function

1804. How to use the WRAPROWS function

1805. CHOOSEROWS Function example

1806. CHOOSEROWS Function example - array

1807. CHOOSEROWS Function example - split text to array

_____CHOOSEROWS Function example - negative values

_____CHOOSEROWS Function errors

_____CHOOSEROWS Function - values in random order

1808. CHOOSEROWS Function - multiple source ranges

_____Get every other row

_____DROP Function example - exclude columns and rows

_____TAKE Function example - return columns and rows

1809. TOROW Function example

_____TOROW Function example - by column

_____TOROW Function - blanks and errors

_____TOROW Function alternative

_____TOROW Function - values in random order

_____Extract unique distinct rows from multiple cell ranges

1810. WRAPROWS Function example

1811. WRAPROWS Function example - pad with

_____WRAPROWS Function alternative

_____WRAPROWS Function - values in random order

1812. WRAPROWS Function - multiple source ranges

1813. How to use the BYROW function

_____How to count the top 10 numbers in a cell range per row

_____How to count the bottom 10 numbers in a cell range per row

_____How to count the top 10 numbers in a cell range (column-wise) per row

_____Multiply numbers in each row by entire cell range

_____How to use the WRAPROWS function

_____WRAPROWS Function example

_____WRAPROWS Function example - pad with

_____WRAPROWS Function alternative

_____WRAPROWS Function - values in random order

_____WRAPROWS Function - multiple source ranges

_____How to create a string containing column and row delimiting characters

_____How to calculate the relative position of column and row

_____Sort based on row count

1814. Sort based on frequency row-wise

1815. Unique distinct rows

_____Extract unique distinct rows

_____Extract unique distinct rows ignoring blank rows

_____Extract unique distinct rows sorted from A to Z ignoring blank rows

1816. Unique rows

_____Extract unique rows

_____Extract unique rows ignoring blank rows

_____Extract unique rows sorted from A to Z ignoring blank rows

_____Highlight rows/records

_____Highlight a row if the date is yesterday

_____Highlight a row if the date is today

_____Highlight a row if the date is tomorrow

_____Highlight a row if the date is in the last 7 days

_____Highlight a row if the date is last week

_____Highlight a row if the date is in this week

_____Highlight a row if the date is in next week

_____Highlight a row if the date is in the last month

_____Highlight a row if the date is in this month

_____Highlight a row if the date is in the next month

_____Record macro while running TextToColumns Wizard?

1817. Sort rows based on the geometric mean

_____How to copy every n-th row from a list

1818. Sort rows by variance based on a sample of a population

1819. Sort rows by the variance of a population

1820. Sort rows by standard deviation of a sample

_____Extract records containing negative numbers

1821. Sort rows based on the median values

_____Assign records unique random text strings

_____Count non-empty cells per row

_____Sort rows based on the number of non-empty cells

1822. How to use the ROWS function

_____Count rows in an array

_____Count rows based on a condition

_____Count rows in a string

_____Count rows in multiple cell ranges

_____Get the highest number within each row

_____Sort rows by their highest number within each row

_____Sort columns by their highest number within each row

_____Count numbers per row

_____Sort rows based on number count

_____Get value based on row and column number

_____Get value based on row and column number - ADDRESS function alternative

_____Get value based on a row and column number and a worksheet name

_____Count identical values if they are on the same row

_____Count rows with data

_____Count non-empty rows

_____Return the row number of the last value in a column

_____Match two columns and return another value on the same row

_____Match two columns and return another value on the same row (array formula)

_____Match two columns and return another value on the same row (regular formula)

_____Match two columns and return another value on the same row - case sensitive

_____Match two columns and return another value on the same row - partial match

1823. How to sum a row?

1824. Sum a given row using a formula

1825. How to add a row

_____How to delete an Excel Table row

1826. Reference a value on the same row

_____Extract rows where any cell is equal to a condition

1827. How to add fields to Pivot Table Row Labels

_____Extract unique distinct records

_____Row and column grand totals

_____TEXTJOIN function - how to add row delimiting characters

_____Concatenate cell values in a row into a single cell

_____Concatenate a multi-column and multi-row cell range

_____What happens if you transpose a range with the same number of columns and rows?

_____How to calculate the first row number of two cells containing search values next to each other vertically?

_____How to calculate row numbers of two cells containing search values next to each other vertically?

_____Highlight unique distinct records

_____Identify rows of overlapping records

_____Identify rows of overlapping records - Excel 365

_____Identify rows of overlapping records - earlier versions

_____Macro deletes entire row if the formula returns blanks

_____Prevent duplicate records in a worksheet

_____Cell ranges with an equal number of rows and columns

_____Cell ranges with different number of rows and columns, ex 1

_____Cell ranges with different numbers of rows and columns, ex 2

1828. Calculate totals row-wise

_____SMALL and ROWS function combined?

1829. How to use the ROW function

_____ROW function - duplicate columns

1830. Number rows in any cell range

1831. How to number rows

_____COUNTIFS function - Count duplicate records

_____COUNTIFS function - return an array identifying records based on multiple conditions

_____How to get a value in a given cell range based on a row number

_____How to return all values in a row or column in a given cell range with the INDEX function

_____Get a value in a given cell range based on a row and column number

_____How to return the entire row in a given cell range using the INDEX function

_____Count groups of repeated values per row

_____Highlight every other row

_____XLOOKUP of three columns to pull a single record

_____FILTER records based on three conditions

1832. Reference Excel Table row

_____Unique distinct records sorted based on count or frequency

_____Unique distinct records sorted based on count - Excel 365

_____Unique distinct records sorted based on count - Pivot Table

_____Unique distinct records sorted based on count or frequency - earlier Excel versions

1833. Format entire row

_____Highlight unique rows (COUNTIFS function)

_____Highlight records - multiple criteria - OR logic

_____Highlight records - AND logic

_____Highlight records containing text strings - AND Logic

_____Filter duplicate records - Autofilter

1834. Copy selected rows based on check boxes

_____Filter shared records from two tables

_____Filter unique distinct records case sensitive

_____Filter unique rows case sensitive - Excel 365 LAMBDA function

_____Count unique distinct rows case sensitive

_____Filter unique distinct rows case sensitive - Excel 365 recursive LAMBDA function

_____Count unique distinct rows case sensitive

_____Compare two lists of data and highlight common records

_____Count unique distinct records

_____Count records with possible blank rows in data set

_____How to count blank rows/records

_____Count unique distinct records based on a date and column criteria

_____Compare tables: Filter records occurring only in one table

_____Remove common rows between two Excel defined tables

_____Remove common rows using an array formula between two data sets

_____Compare two tables using a condition and filter shared records

_____Sort rows based on frequency and criteria

_____Sort rows based on frequency and criteria - Excel 365

_____Sort rows based on frequency and criteria - earlier versions

_____Create dependent drop down lists containing unique distinct values in multiple rows

_____Dependent drop-down lists in multiple rows

_____Match two criteria and return multiple records

_____Match two criteria and return multiple records [Array Formula]

_____Match two criteria and return multiple records [Excel 365]

_____Match two criteria and return multiple records [Excel defined Table]

_____Match two criteria and return multiple records [Advanced Filter]

_____Filter records based on a date range and if a cell value contains a string

_____Extract records where all criteria match if not empty

_____Create a number sequence to count records by year and month (sorted list)

_____Create a number sequence to count records by year and month (unsorted list)

_____Create a number sequence to count records by individual products and years

_____If value in range then return value - INDEX + SUMPRODUCT + ROW

_____Use VLOOKUP to search date in date ranges and return value on the same row

_____Lookup and find the most recent date, return another value on the same row

_____VLOOKUP - Extract multiple records based on a condition

_____Extract all rows from a range that meet criteria in one column

_____Extract all rows from a range based on range criteria (Array formula)

_____Extract all rows from a range based on range criteria - Excel 365

_____Extract all rows from a range based on multiple conditions (Array formula)

_____Extract all rows from a range based on multiple conditions - Excel 365

_____Extract all rows from a range based on range critera [Excel defined Table]

_____Extract all rows from a range based on range critera [AutoFilter]

_____Extract all rows from a range based on range criteria [Advanced Filter]

1835. Search for a text string in a data set and return multiple records

1836. Search for a text string in a data set and return multiple records [Array formula]

_____Search for a text string in a data set and return multiple records [Excel 365]

1837. Search for a text string in a data set and return multiple records [Excel defined Table]

_____Search for a text string in a data set and return multiple records [Advanced Filter]

_____Search each column for a string each and return multiple records - OR logic

_____How to extract rows containing digits

_____How do I extract rows that contain a string in a data set or table?

_____How do I filter rows that contain a string using Advanced Filter?

_____How do I filter rows that contain a string using an Excel Table?

_____Group rows based on a condition

_____Merge matching rows

_____List duplicate rows / records

_____Label groups of duplicate records

_____Insert blank rows for missing values

_____Count unique distinct records

_____Count records with possible blank rows in data set

_____How to count blank rows/records

_____Count unique distinct records based on a date and column criteria

_____Highlight duplicate records/rows

_____Highlight dates arranged in a row

_____Highlight records

_____Highlight records based on overlapping date ranges and a condition

_____Sort records based on two columns

_____Extract records between two dates

_____Filter rows using array formulas based on a date range - Excel 365

_____Filter rows using array formulas based on a date range - earlier Excel versions

_____Filter rows using an Excel table based on a date range

_____Filter rows based on a date range - Autofilter

_____Filter unique distinct records

_____Filter unique distinct row records

_____Filter unique distinct row records but not blanks

_____Filter unique distinct row records that does not begin with *string*

_____Filter unique distinct row records that begins with *string*

_____Filter unique distinct records [Pivot table]

_____Filter unique distinct records based on a condition

_____Extract unique distinct records based on condition example 2

_____Extract unique distinct records from two data sets

_____List all unique distinct rows in a given month and year

_____List all unique distinct rows in a given month and year (Excel 365)

_____List all rows in a given month and year

_____List all rows in a given month and year (Excel 365)

1838. ROW function and OFFSET function

_____Cleaning Up Excel Worksheets: Eliminating Blank Cells, Rows, and Errors

_____Remove blank rows - formula

_____How to delete empty rows - advanced filter

Recursive

_____Substitute multiple text strings - Excel 365 recursive LAMBDA function

_____Filter unique distinct rows case sensitive - Excel 365 recursive LAMBDA function

_____Fuzzy lookups - Excel 365 recursive LAMBDA function

Reference

1839. IMTAN function example 2 - cell reference

_____Can I use the FILTER function with an Excel Table and structured references?

_____How to count cells in a cell reference

_____Reference isn't valid error

_____Excel found a problem with one or more formula references

1840. How do structured references work?

1841. Reference an entire Excel Table

1842. Reference Excel Table data

_____Reference column headers

_____Reference a column

_____Reference a value on the same row

_____Extract cell references from a formula

1843. How to use cell references in array formulas?

1844. How to use absolute and relative references

1845. How to create a cell reference using the INDIRECT function?

1846. How to create a cell reference to a worksheet name using the INDIRECT function?

1847. How to hardcode a cell reference?

1848. Working with cell references

_____How to build a dynamic cell reference using the INDEX function

1849. Reference Excel Table headers

_____Reference Excel Table column

_____Reference Excel Table row

_____Reference an Excel Table in a Conditional Formatting formula

_____How to reference Excel 365 dynamic array formulas

_____List all named ranges and their cell references

_____Reverse two-way lookups in a cross reference table [Excel 2016]

_____Reverse two-way lookups in a cross reference table [All excel versions]

_____Reverse two-way lookup in a cross reference table

1850. Create a cell reference to a cell range

Relation, related

1851. Comparing related functions and techniques

1852. Comparing related functions

1853. Working with Relational Tables in Excel

1854. Search for values in a related table

_____Search for values in a related table - Excel 365

1855. Sum values in a related table

_____Sum values in a related table - Excel 365

_____Highlight lookups in relational tables

_____Merge two relational data sets

1856. Working with three relational tables

_____Extract unique distinct values from a relational table

Reverse

_____How to perform a reverse search - starting with the last item

_____Example 7 - reverse a list using the SEQUENCE function

_____MID function - reverse characters in value

1857. How to create a reverse running total?

1858. Reverse horizontal axis

_____Lookup and match last value - reverse lookup

1859. Reverse text

_____Reverse two-way lookups in a cross reference table [Excel 2016]

_____Reverse two-way lookups in a cross reference table [All excel versions]

_____Reverse two-way lookup in a cross reference table

_____Reverse a list ignoring blanks

_____Reverse a list ignoring blanks - Excel 365

_____Reverse a list ignoring blanks - manual steps

Right, left

_____EXPAND Function example - how to extend an array up and left

_____Rearrange values to the left if the cell is empty as far as possible

1860. Search right to left

1861. Calculate the hypothenuse in a right triangle

1862. Calculate the legs (opposite and adjacent) in a right triangle

1863. How to use the SIN function with a right or right-angled triangle

1864. Substitute from right

1865. How to use the RIGHT function

1866. How to use the LEFT function

1867. LEFT function Example

_____LEFT until character

_____LEFT function until space

_____LEFT function until second space

1868. LEFT until dash

1869. LEFT until number

_____LEFT function remove characters

1870. LEFT function for numbers

1871. MID function from right

_____How to insert 0 (zeros) to the right of the decimal point

_____How to add 0 (zeros) to the right and left of the decimal point

_____VLOOKUP - What if the lookup value is not in the leftmost column?

1872. Alright, show me some useful array formulas?

_____Place image next to the upper-right corner of shape

_____Place image next to the upper-left corner of shape

_____Place image next to the lower-left corner of shape

_____What if I don't have the lookup column in the left-most column?

Running total

1873. How to create a running total (SUM function)?

_____How to create a reverse running total?

1874. Working with running totals

_____Running totals based on criteria - formula

_____Running totals based on criteria - formula and Excel Table

_____Running totals based on criteria - Excel Table

1875. How to create running totals

Schedule

_____Get date ranges from a schedule

_____Get date ranges from a schedule - Excel 365

_____Get date ranges from a schedule - earlier Excel versions

_____Extract dates from a cell block schedule

1876. Shift Schedule

1877. Watch schedule that populates vacation time

_____Schedule project dates based on a finish date

1878. Basic schedule - each team plays once against another team

1879. Weekly schedule template

_____Setting up your work hours in a weekly schedule

_____Highlight specific time ranges in a weekly schedule

_____Schedule recurring expenses in a calendar

1880. Free School Schedule Template

_____Populate cells dynamically in a weekly schedule

_____Find empty hours in a weekly schedule

1881. Using Excel Solver to schedule employees

Second

_____How to calculate the second solution of the square root of a complex number?

1882. How to use the SECOND function

_____Seconds value larger than 59

1883. TIME function - how to add seconds

_____How to use the SECOND function

_____Seconds value larger than 59

_____TIME function - how to add seconds

_____Lookup value based on two critera – second criteria is the adjacent value and its position in a given list

Sequence, consecutive

1884. How to use the SEQUENCE function

1885. Example 3 - create a repeating sequence

1886. Example 4 - create repeated numbers in a sequence

_____Example 5 - create blanks in a sequence of numbers

1887. Example 6 - format numbers in sequence with leading zeros

_____Example 7 - reverse a list using the SEQUENCE function

_____Example 8 - sequence of dates based on a start date

_____Example 9 - sequence of months

1888. Example 10 - sequence of weeks

1889. Example 11 - sequence of quarters

_____Example 12 - sequence of letters

1890. Example 13 - sequence of cells?

_____Alternative to the SEQUENCE function?

1891. Create a horizontal sequence

_____Search for a sequence of cells based on wildcard search

_____Lookup for a multi-level sequence

_____Lookup for multiple multi-level sequences

_____Wildcard search for a sequence

_____Wildcard search for multiple sequences

1892. Search for a sequence of values

_____How to find a sequence with any value between?

_____Find multiple sequences with any value between?

_____Find all sequences of consecutive dates

_____Find all sequences of consecutive dates - Excel 365

_____List non consecutive dates - Excel 365

_____Find all sequences of consecutive dates - earlier Excel versions

_____List non consecutive dates - earlier Excel versions

_____Highlight consecutive dates using Conditional Formatting

_____List consecutive numbers

_____List non consecutive numbers

1893. Create number sequences (Autofill)

1894. Create a repeating number sequence

_____Create a number sequence and restart when a cell value equals a condition

_____Create a number sequence to count records by year and month (sorted list)

_____Create a number sequence to count records by year and month (unsorted list)

_____Create a number sequence to count dates based on year

_____Create a number sequence to count items

_____Create a number sequence to count prices within given amounts

_____Create a number sequence to count records by individual products and years

_____Create a date sequence

Shared, common, exist, occur

_____Highlight a date occurring...

_____How to check if boolean values exist in a given cell range?

_____Count how many times a string exists in a cell range (case insensitive)

_____Extract values that exist only in one of the two columns

_____Extract values that exist only in one of the two columns - Excel 365

_____Filter values occurring in range 1 but not in range 2

_____How to extract not shared values in two columns

_____Filter shared records from two tables

_____Filter values that exists in all three columns

_____How to highlight differences and common values in lists

_____Compare two columns and highlight values in common

_____Compare two lists of data and highlight common records

_____Compare tables: Filter records occurring only in one table

_____Remove common rows between two Excel defined tables

_____Remove common rows using an array formula between two data sets

_____Compare two tables using a condition and filter shared records

_____Filter values in common between two cell ranges

_____Filter values in common between two cell ranges - Excel 365

_____Filter values in common between two cell ranges - Excel 2019

_____Filter values in common between two cell ranges - earlier versions

_____Extract shared values between two columns

_____Extract shared values between two columns - Excel 365

_____Extract shared values between two columns (case sensitive)

_____Filter common values from three separate columns

Small, smaller, less

_____Example 2 - aggregate by category and sort from large to small

_____How to sort from smallest to largest?

_____How to sort from largest to smallest?

_____Sum numbers based on items and return totals sorted from large to small

_____Filter values if smaller than

_____Get the smallest number larger than a given number and a condition

_____Get the smallest number larger than a given number and criteria

_____SWITCH Function - how to use logical operators like larger than and smaller than

_____MAXIFS function - smaller than

_____Find smallest and largest unique number

_____Column function and SMALL function

_____AVERAGEIF function - smaller than

_____How to extract the smallest number from filtered data?

_____How to sum if a number is smaller than a given condition

_____How to sum values greater than smaller than?

_____Find the largest value in lookup_vector that is less than or equal to lookup_value

1895. How to use the SMALL function

_____How to use SMALL function with criteria?

_____SMALL and ROWS function combined?

1896. SMALL function with multiple cell ranges

_____How to ignore error values using the SMALL function

_____SMALL function – INDEX MATCH

_____SMALL function – INDEX MATCH - Excel 365

_____How to ignore zeros using the SMALL function

_____SMALL function - multiple conditions

1897. SMALL function for text

_____SMALL function ignore duplicates

_____Find the smallest number in a list that is larger than a given number

_____IF function - smaller than

_____Example 2 - Count cells larger/less than a criterion

_____VLOOKUP and return multiple values - if smaller than

_____Highlight the smallest duplicate number

_____Get the largest/smallest number

_____Get the column header name that contains the largest/smallest value

_____Get the cell address of the largest/smallest number

_____Create a link to the largest/smallest number

_____How to highlight the largest and smallest value

Solver

1898. Solve linear equations using Solver

_____Test combinations (Solver)

_____Find the optimal permutation - Excel Solver

1899. Excel solver examples

_____Using Excel Solver to schedule employees

_____Identify numbers in sum using Excel solver

Sort, A to Z, z to a, ascending, descending

_____Example 2 - aggregate by category and sort from large to small

_____Example 9 - aggregate values and sort by count

_____Sort in random order

1900. How to use the SORTBY function

1901. SORTBY Function example

_____Why does the SORTBY function return a #SPILL! error?

_____The SORTBY function returns a #NAME! error?

_____Does the SORTBY function differentiate between upper and lower letters?

1902. How to sort from A to Z?

1903. How to sort from Z to A?

_____How to sort from smallest to largest?

_____How to sort from largest to smallest?

_____How to sort by multiple columns?

_____Sort by another column

_____How to sort by the first letter/digit?

_____How to sort by the first letter - Example 2

_____How to sort by the first digit - Example 3

1904. How to sort by absolute value?

_____How to sort by the last word in a cell?

_____How to sort by the first name?

_____How to sort by the last name?

_____How to sort by custom list?

_____How to sort by month?

1905. Sort by word length

_____Sort in random order

_____Sort unique values in random order

1906. Sort by week number

1907. Sort by quarter

_____Sort based on row count

1908. Sort numbers based on proximity to a given number

_____Sort based on frequency row-wise

1909. How to use the SORT function

1910. SORT Function example

_____Why does the SORT function return a #SPILL! error?

_____How to sort a multicolumn cell range

_____How can I sort letters and numbers?

_____Sort based on values in an adjacent column

_____Is the SORT function case sensitive?

1911. Can you sort data based on an Excel Table?

_____Sort by column (vertically)?

_____How to sort by column header?

_____Sum numbers based on items and return totals sorted from large to small

_____Sort based on item count

_____How to sort a multicolumn cell range

1912. Sort items by adjacent number in every other value - Array formula

_____Sort items by adjacent number in every other value - Excel 365 formula

1913. Sort items by adjacent number in every other value horizontally

_____Sort values in a cell based on a delimiting character (Formula)

_____Sort values in a cell based on a delimiting character (Macro)

_____Filter values based on a condition sorted from A to Z

_____Lookup and return multiple sorted values based on corresponding values in another column - Excel 365

_____Lookup and return multiple sorted values based on corresponding values in another column - previous Excel versions

_____Lookup and return multiple sorted values based on corresponding values in another column - Excel Table

_____Extract unique distinct values sorted from A to Z

_____Extract unique distinct values sorted from A to Z ignoring blanks

_____Extract unique values sorted from A to Z

_____Extract unique values sorted from A to Z ignoring blanks

_____Extract unique distinct rows sorted from A to Z ignoring blank rows

_____Extract unique rows sorted from A to Z ignoring blank rows

_____Sort rows based on the geometric mean

_____Sort columns based on the geometric mean

_____Sort rows by variance based on a sample of a population

_____Sort rows by the variance of a population

_____Sort rows by standard deviation of a sample

_____Sort rows based on the median values

_____Sort columns based on the median values

_____Sort and return unique distinct single digits from cell range - Excel 365

_____Sort rows based on the number of non-empty cells

_____Sort columns based on the number of non-empty cells

_____Sort rows by their highest number within each row

_____Sort columns by their highest number within each row

_____Sort rows based on number count

_____Sort columns based on number count

_____Sort highlighted numbers

1914. How to sort an Excel Table

1915. Sort data

_____Compare two columns and return differences sorted from A to Z

_____Compare two columns and return differences sorted from A to Z - Excel 365

_____Find last matching value in an unsorted list

_____Sort data

_____Sort by multiple columns

_____Sort by multiple columns using an Excel Table

_____Sort by multiple columns using the SORTBY function (Excel 365)

_____Sort by multiple columns using formula (Previous Excel versions)

_____Sort highlighted values

_____Sort column based on frequency

_____Lookup_array in ascending order

_____Lookup_array in descending order

1916. Sort data set using formula

_____Sort data set using Excel's "Sort & Filter"

_____Sort dates within a date range

_____Unique distinct records sorted based on count or frequency

_____Unique distinct records sorted based on count - Excel 365

_____Unique distinct records sorted based on count - Pivot Table

_____Unique distinct records sorted based on count or frequency - earlier Excel versions

_____Sort rows based on frequency and criteria

_____Sort rows based on frequency and criteria - Excel 365

_____Sort rows based on frequency and criteria - earlier versions

_____Create a drop down list containing alphabetically sorted values

_____Create a number sequence to count records by year and month (sorted list)

_____Create a number sequence to count records by year and month (unsorted list)

_____Match a date when a date range is entered in two cells sorted in ascending order

_____Match a date when a date range is entered in two cells with gaps not sorted

_____Extract multiple values based on a search value sorted from A to Z

_____Extract multiple values based on a search value sorted from A to Z (Excel 365)

_____Extract unique distinct values sorted based on sum of adjacent values

_____Extract unique distinct values sorted based on sum of adjacent values - Excel 365

_____Extract unique distinct values sorted based on sum of adjacent values - earlier Excel versions

_____Filtering unique distinct text values and sorting them based on the sum of adjacent values and criteria - earlier Excel versions

_____Filtering unique distinct text values and sorting them based on the sum of adjacent values and criteria - Excel 365

_____How to list unique distinct values sorted by frequency

_____Unique distinct values sorted based on frequency (single column)

_____Unique distinct values sorted based on frequency - Excel 365

_____Unique distinct values sorted based on frequency (multiple columns)

_____Unique distinct values sorted based on frequency (multiple columns) - Excel 365

_____Sort text cells alphabetically from two columns

_____Sort text from two columns combined (array formula)

_____Merge and then sort text from two columns combined (array formula)

_____Filter duplicate values and sort by corresponding date

_____Extract a list of alphabetically sorted duplicates from a column

_____Extract a list of alphabetically sorted duplicates based on a condition

_____Extract a list of alphabetically sorted duplicates based on a condition - Excel 365

_____Populate drop down list with unique distinct values sorted from A to Z

1917. Sort values using array formula

1918. Sort values

_____Extract a unique distinct list sorted from A to Z

_____Unique distinct list sorted alphabetically based on a condition - Earlier Excel versions

_____Unique distinct list sorted alphabetically based on a condition - Excel 365

_____Unique distinct list sorted alphabetically based on a numerical range - Earlier Excel versions

_____Unique distinct list sorted alphabetically based on a numerical range - Excel 365

_____Extract a unique distinct list sorted from A to Z and ignore blanks - earlier Excel versions

_____Create a unique distinct sorted list containing both numbers and text removing blanks with a condition - earlier Excel versions

_____List unique distinct sorted values removing blanks based on a condition - Excel 365

_____Create a unique distinct sorted list containing both numbers and text removing blanks with a condition - Excel 365

_____Create unique distinct list sorted based on text length

_____Filter unique values and sort based on adjacent date - Excel 365

_____Filter unique values sorted from A to Z

_____Sort a column alphabetically

_____Sort a column - Excel 365

_____Sort a column using array formula

_____Two columns sorting by the second column - Excel 365

_____Two columns sorting by the second column

1919. Sort alphanumeric values

1920. Sort text values by length

_____Sort two columns

_____Sort records based on two columns

_____Sort items by adjacent number in every other value - Array formula

_____Sort items by adjacent number in every other value - Excel 365 formula

1921. Sort items by adjacent number in every other value vertically

_____Sort a multi-column cell range from A to Z - array formula for older Excel versions

_____Extract unique distinct values A to Z from a range and ignore blanks - Excel 365

_____Extract unique distinct values A to Z from a range and ignore blanks

_____Filter unique distinct values, sorted and blanks removed from a range

_____Extract a unique distinct list sorted from A-Z from range

Split

_____CHOOSEROWS Function example - split text to array

_____Split characters horizontally to a cell each

1922. How to use the TEXTSPLIT function

1923. TEXTSPLIT Function example

_____TEXTSPLIT function - remove #N/A errors

1924. TEXTSPLIT function - pad each value with a given string

_____Split string using multiple delimiting characters

_____How to split date value

1925. Split search value using a delimiter and search for each substring

1926. How to use the SPLIT function

_____Split string and remove decimals

_____Split date from a date and time value

_____Split time from a date and time value

_____Split characters to a cell each horizontally counting backwards

_____MID function - split characters into an array

_____Prepare data for Pivot Table - How to split concatenated values?

_____Workaround for the TEXTSPLIT function - LAMBDA function

_____Split expenses calculator

_____How to split expenses evenly (Excel 365)

1927. A Comprehensive Guide to Splitting Text in Excel

_____Split words in a cell - blank as a delimiting character

_____Split words in a cell - any delimiting character(s)

_____Split words in a cell - Excel 365 formula

_____Split words in a cell - Excel 365 formula - any delimiting character(s)

1928. Split words in a cell - Rick Rothstein's formula

_____Split words in a cell - Rick Rothstein's formula - Any delimiting character(s)

_____Split words in a cell - FILTERXML function - any a delimiting character

_____Split words in a cell range into a cell each - Excel 365

_____Split values equally into groups

String

_____How to extract the year from a text string

_____Extract year when the date is located at the end of the text string

_____Extract year when the date is located somewhere in the middle of the text string

_____Extract year when the date is located at the beginning of the text string

_____TEXTSPLIT function - pad each value with a given string

_____Split string using multiple delimiting characters

_____How to create a string containing column and row delimiting characters

_____Split search value using a delimiter and search for each substring

_____Extract string between two substrings

_____Highlight cells containing string

_____Substitute multiple text strings - Excel 365 recursive LAMBDA function

_____Find and replace strings in file names, folder name and subfolders

1929. How to decode URL-encoded strings

_____FIND function returns all positions of a given substring

_____Create random text strings

_____Random text strings

_____Assign records unique random text strings

_____Split string and remove decimals

1930. CLEAN function - string

_____Count blanks in a text string

_____Count non-empty values in a string

_____Count columns in a string

_____Count rows in a string

_____LARGE function - based on a textstring

_____How to convert comma delimiting numbers to a string of characters

1931. How to convert string to ANSI numbers - CODE Function

_____Identify digits in a string

1932. Substitute multiple strings

_____Substitute all letters with a given string

_____Count specific multiple text strings in a given cell range

_____Count a specific text string in a cell (case sensitive)

_____Count text string in a range (case sensitive)

_____Count how many times a string exists in a cell range (case insensitive)

_____How to extract the year from a text string

_____Extract year when the date is located at the end of the text string

_____Extract year when the date is located somewhere in the middle of the text string

_____Extract year when the date is located at the beginning of the text string

_____Count matching strings using regular expressions

1933. Convert string to HEX

1934. Convert string to ASCII

1935. Convert string to Base64

1936. Decode a Base64 value to string - Excel formula

_____What happens if a text string is used in the logical expression?

_____Example 3 - Count cells containing a text string - partial match (wildcard)

_____Match cell that contains a given string

_____Match cell that begins with a specific string and ends with another string - any number of characters in between

_____Match cell that begins with string and ends with another string - a single character in between

_____Search and display all cells that contain all search strings

_____Highlight records containing text strings - AND Logic

_____Filter unique distinct values where adjacent cells contain search string

_____Extract unique distinct values from cell range that begins with string

_____Extract unique distinct text values containing string in a range

_____Extract values between two given delimiting strings

_____Filter strings containing a given substring in a cell range

_____Filter words containing a given string in a cell range - Excel 365 LAMBDA function

_____Match if cell contains string [Array Formula]

_____Searching for the first characters in a text string [Array Formula]

_____Filter records based on a date range and if a cell value contains a string

_____Extract unique distinct values if the value contains the given string

_____Extract unique distinct values if the value contains the given string - Excel 365

_____Extract unique distinct values if the value contains the given string - earlier Excel versions

_____Filter duplicate values from a range that begins with string

_____Search for a text string in a data set and return multiple records

_____Search for a text string in a data set and return multiple records [Array formula]

_____Search for a text string in a data set and return multiple records [Excel 365]

_____Search for a text string in a data set and return multiple records [Excel defined Table]

_____Search for a text string in a data set and return multiple records [Advanced Filter]

1937. Exact word in string

_____Search each column for a string each and return multiple records - OR logic

_____How do I extract rows that contain a string in a data set or table?

_____How do I filter rows that contain a string using Advanced Filter?

_____How do I filter rows that contain a string using an Excel Table?

_____Partial match for multiple strings – AND logic

_____Partial match for multiple strings - AND logic - returns the first match

_____Partial match for multiple strings - AND logic - returns all matches

_____Partial match for multiple strings - AND logic - returns all matches (Excel 365)

_____Partial match for multiple strings - AND logic - returns all corresponding values

_____Filter unique strings from a cell range

_____Filter unique strings in a range - Excel 365

_____Extract unique distinct text values containing string in a range - Excel 365

_____Extract unique distinct values from cell range that begins with string - Excel 365

_____Filter unique distinct row records that does not begin with *string*

_____Filter unique distinct row records that begins with *string*

Substitute, replace

1938. How to use the REPLACE function

1939. REPLACE function example

1940. REPLACE function not working

1941. How to replace part of formula in all cells

_____Substitute multiple text strings - Excel 365 recursive LAMBDA function

_____Find and replace strings in file names, folder name and subfolders

1942. How to use the SUBSTITUTE function

_____Substitute multiple strings

_____Substitute from right

_____Substitute all letters with a given string

1943. Substitute all numbers

1944. Substitute based on table

1945. How to substitute double quotes

_____Can you replace the VLOOKUP function with the INDEX function?

Subtotal

1946. How to use the SUBTOTAL function

_____Does the SUBTOTAL function avoid double counting?

1947. How to include manually hidden values in the SUBTOTAL function?

_____How to exclude manually hidden values from the SUBTOTAL function?

1948. How to use the Subtotal tool

1949. Start the Subtotal tool

1950. Subtotals on multiple levels

_____Count cells based on conditionally formatted background color using Filter tool and SUBTOTAL function [Excel 365]

1951. SUBTOTAL and OFFSET functions

Sum, total

_____Example 1 - create totals by category

1952. Example 3 - summarize by two categories

1953. Example 4 - create totals by year

1954. Example 6 - summarize by year and quarter

1955. Example 7 - create totals by year and week

_____Example 8 - create totals and count in the same column

1956. How to use the IMSUM function

1957. IMSUM function example

_____How to calculate the sum of two complex numbers in rectangular form?

_____How to plot the sum of two complex numbers?

_____Sum numbers based on items and return totals sorted from large to small

1958. How to use the SUMXMY2 function

1959. How to use the SUMX2MY2 function

1960. How to use the SUMSQ function

_____Count total characters in multiple cell ranges combined

1961. Example 7 - SUM

_____How to sum overlapping time

_____Calculate a sum based on a case sensitive condition

_____Convert negative numbers to positive and calculate the sum

_____How do I sum values between n-th weekday this month and n-th weekday next month?

_____Sum cells based on criteria

_____Sum values between two dates and based on a condition

_____How to sum filtered data?

_____How to sum based on a condition

_____How to sum based on a condition in another column

_____How to sum if a number is smaller than a given condition

_____How to sum if a number is larger than a given condition

_____How to sum based on a date

_____How to sum if a date is later than a given condition

_____How to sum if a date is earlier than a given condition

_____How to sum numbers using a list of conditions

_____How to sum not equal to

_____How to sum by group

1962. How to use the SUM function

_____How to add numbers in a column and return a total (SUM function)?

1963. How to add numbers in an array (SUM function)?

1964. How to sum specific cells?

1965. How to sum numbers from multiple cell ranges (SUM function)?

_____How to sum a column with text (SUM function)?

1966. How to sum boolean values?

_____How to create a running total (SUM function)?

_____How to sum numbers based on a condition/label/item/category?

_____SUM with multiple conditions

1967. How to sum only visible cells?

_____How to sum a filtered column?

_____How to sum the entire column?

_____How to sum a row?

1968. How to sum across worksheets?

1969. How to sum by color?

1970. How to sum absolute values?

1971. What is the shortcut key for the SUM function?

_____How to sum values greater than smaller than?

1972. How to sum values below/above 0 (zero)?

1973. How to limit SUM function?

_____How to sum a column and ignore errors?

_____How to sum values by date?

1974. How to sum values by week?

_____How to sum values by month?

1975. How to sum values by year?

_____How to sum values between two dates?

_____How to create a reverse running total?

1976. Sum cells with check boxes

1977. How to sum selected values

_____Sum a column using a formula

_____Sum a given column using a formula

_____Sum a given row using a formula

1978. Sum using an Excel defined Table

_____Sum cells containing numbers and text based on a condition

1979. Sum unique numbers

_____VLOOKUP sum

_____How to insert a total to an Excel Table and sum using a condition

1980. How to show Excel Table totals

1981. Totals worksheet

1982. Summarize and analyze

_____Row and column grand totals

_____Find numbers closest to sum

_____Find numbers closest to sum - Excel 365

_____Find numbers in total with a condition

_____Find numbers in total with a condition - Excel 365

1983. How to create an INDIRECT sum?

_____Remove totals

1984. Sum numerical ranges between two numbers

1985. Sum unique distinct invoices

_____Sum based on OR - AND logic

_____Find empty cells and sum cells above

_____Calculate totals row-wise

_____Calculate totals column-wise

_____Sum values in a related table

_____Sum values in a related table - Excel 365

_____Working with running totals

_____Running totals based on criteria - formula

_____Running totals based on criteria - formula and Excel Table

_____Running totals based on criteria - Excel Table

_____How to create running totals

_____Compare two lists and filter unique values where the sum in one column doesn't match the other column

_____How to calculate totals of stock transactions based on dates

_____Identify numbers in sum using Excel solver

_____Extract unique distinct values sorted based on sum of adjacent values

_____Extract unique distinct values sorted based on sum of adjacent values - Excel 365

_____Extract unique distinct values sorted based on sum of adjacent values - earlier Excel versions

_____Filtering unique distinct text values and sorting them based on the sum of adjacent values and criteria - earlier Excel versions

_____Filtering unique distinct text values and sorting them based on the sum of adjacent values and criteria - Excel 365

_____Extract a unique distinct list and sum amounts based on a condition - earlier Excel versions

_____Extract a unique distinct list and sum amounts based on a condition - Excel 365

Sumif

1986. How to use the SUMIF function

_____How to use an asterisk to perform a wildcard match in the SUMIF function

1987. How to use a question mark in the SUMIF function

_____SUMIF across multiple sheets - Excel 365

_____SUMIF across multiple sheets - macro

Sumifs

_____How to use the SUMIFS function

_____SUMIFS function greater than

_____SUMIFS function not equal

_____SUMIFS function multiple criteria

_____SUMIFS function or

_____SUMIFS Function example using partial match

_____How to use logical operators in the SUMIFS function

Sumproduct

_____SUMPRODUCT and IF function

_____How to simplify IF functions in the SUMPRODUCT function

_____SUMPRODUCT if greater than 0 (zero)

_____SUMPRODUCT if between two dates

_____SUMPRODUCT if cell contains text

_____SUMPRODUCT if or

_____SUMPRODUCT – multiple criteria

_____SUMPRODUCT - based on a list of values

_____SUMPRODUCT - multiple conditions and a date range

_____SUMPRODUCT - multiple date ranges

_____SUMPRODUCT - sum based on daily currency rates

_____How to use the SUMPRODUCT function

_____Things to know about the SUMPRODUCT function

_____How to use the SUMPRODUCT function

_____How to use a logical expression in the SUMPRODUCT function

_____How to use multiple conditions in the SUMPRODUCT function

_____How to use OR logic in the SUMPRODUCT function

_____SUMPRODUCT and nested IF functions

_____SUMPRODUCT if not blank

_____SUMPRODUCT returns nothing (blank)

_____SUMPRODUCT if not NA

_____SUMPRODUCT if not error

_____If value in range then return value - INDEX + SUMPRODUCT + ROW

Tab

1988. How to create a tab in an Excel formula

1989. Tabula recta

Table, excel table

_____Two-way lookup using multiple tables

_____Can you sort data based on an Excel Table?

_____Can I use the FILTER function with an Excel Table and structured references?

_____Lookup and return multiple sorted values based on corresponding values in another column - Excel Table

1990. How to create a frequency table based on text values

1991. How to create a frequency table based on numerical values

_____Count columns in multiple Excel Tables

_____Extract table headers based on a condition

_____Substitute based on table

_____How to filter using OR logic between columns - Autofilter and Excel tables

_____How to create a link to an Excel Table

_____Locate lookup values in an Excel table

_____Filter duplicate values using criteria - Excel Table

_____Sum using an Excel defined Table

_____HLOOKUP - multiple tables

_____VLOOKUP - how to use multiple tables

_____How can I use multiple tables to calculate a discount based on different price levels?

_____How to perform two-way lookup in multiple tables - 2D

1992. How to use Excel Tables

1993. How to create an Excel Table

1994. How to name an Excel Table

1995. How to manipulate Excel Table data

1996. How to edit an Excel Table value

_____How to delete an Excel Table value

_____How to delete an Excel Table row

_____How to delete an Excel Table column

_____How to delete an Excel Table and keep values

_____How to sort an Excel Table

_____How to filter an Excel Table

_____How to insert a total to an Excel Table and sum using a condition

_____Reference an entire Excel Table

_____Reference Excel Table data

1997. How to use a formula in an Excel Table

1998. How to change Excel Table formatting

_____How to show Excel Table totals

_____List all tables in a workbook - Named ranges

_____How to link a drop-down list to an Excel Table (Data validation)

_____Working with filtered Excel Tables

_____How to quickly find an Excel Table in a workbook

_____Change PivotTable data source using a drop-down list

_____Highlight unique values in a filtered Excel table

_____Merge tables based on a condition

_____Sort by multiple columns using an Excel Table

1999. Excel Table and slicers

2000. How to quickly select a named range or an Excel table

2001. Create an Excel Table

2002. Why do I want to convert the data set to an Excel Table?

_____VLOOKUP in a filtered Excel Table and return multiple values

_____How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas – use named ranges

_____Reference Excel Table headers

_____Reference Excel Table column

_____Reference Excel Table row

_____Reference an Excel Table in a Conditional Formatting formula

_____Working with Relational Tables in Excel

_____Search for values in a related table

_____Search for values in a related table - Excel 365

_____Sum values in a related table

_____Sum values in a related table - Excel 365

_____Highlight lookups in relational tables

_____Working with three relational tables

_____Extract unique distinct values from a relational table

2003. Populate combo box with values from a table

_____Extract unique distinct values in an Excel Table filtered list

_____List unique distinct values in a filtered Excel defined Table - Excel 365

_____List unique distinct values in a filtered Excel defined Table - earlier Excel versions

_____Count unique distinct values in a filtered Excel defined Table

_____Populate drop down list with filtered Excel Table values

_____How to compare two data sets - Excel Table and autofilter

_____Filter shared records from two tables

_____Running totals based on criteria - formula and Excel Table

_____Running totals based on criteria - Excel Table

_____Two index table

_____Compare two tables and highlight differences

_____Compare tables: Filter records occurring only in one table

_____Remove common rows between two Excel defined tables

_____Compare two tables using a condition and filter shared records

_____Match two criteria and return multiple records [Excel defined Table]

_____Lookup and return multiple values [Excel Defined Table]

_____Extract all rows from a range based on range critera [Excel defined Table]

_____Search for a text string in a data set and return multiple records [Excel defined Table]

_____How do I extract rows that contain a string in a data set or table?

_____How do I filter rows that contain a string using an Excel Table?

_____Reverse two-way lookups in a cross reference table [Excel 2016]

_____Reverse two-way lookups in a cross reference table [All excel versions]

_____Reverse two-way lookup in a cross reference table

_____Two-dimensional lookup using two tables

_____Highlight duplicates in a filtered Excel Table

_____Filter rows using an Excel table based on a date range

Team, tournament

2004. How to generate a round-robin tournament

_____Basic schedule - each team plays once against another team

_____Round-robin tournament - distributes home and away rounds evenly

2005. Double round-robin tournament

2006. True round-robin tournament

2007. Team Generator

_____Dynamic team generator

2008. How to build a Team Generator - different number of people per team

Text

_____How to extract the year from a text string

_____Extract year when the date is located at the end of the text string

_____Extract year when the date is located somewhere in the middle of the text string

_____Extract year when the date is located at the beginning of the text string

2009. Year as text

2010. Example 1 - TEXT function

2011. Example 2 - TEXT function

_____CHOOSEROWS Function example - split text to array

2012. How to use the VALUETOTEXT function

2013. How to use the ARRAYTOTEXT function

_____How to use the TEXTSPLIT function

_____TEXTSPLIT Function example

_____TEXTSPLIT function - remove #N/A errors

_____TEXTSPLIT function - pad each value with a given string

2014. How to use the TEXTAFTER function

2015. TEXTAFTER Function example

_____TEXTAFTER Function - case sensitive example

_____TEXTAFTER Function alternative (all Excel versions)

_____TEXTAFTER Function alternative

_____TEXTAFTER Function alternative case sensitive

2016. How to use the TEXTBEFORE function

_____How to use the TEXTTOCOLUMNS method

_____Record macro while running TextToColumns Wizard?

_____TextToColumns method - dot as delimiting character

_____TextToColumns method - blank as delimiting character

_____How to rank text uniquely without duplicates

_____Extract the most frequent text value - MODE.SNGL function

_____How to create a frequency table based on text values

_____Substitute multiple text strings - Excel 365 recursive LAMBDA function

_____Extract the most frequent text values

2017. How to use the FORMULATEXT function

2018. How to use the ISNONTEXT function

2019. How to use the ISTEXT function

2020. What is text in Excel?

2021. ISTEXT function example

_____Filter text values

_____If cell contains any text

2022. How to format numbers as text

_____Create random text strings

_____Random text strings

_____Assign records unique random text strings

_____Calculate the number of weeks and days between given dates - dynamic text values

_____Count blanks in a text string

_____Max function for text

_____LARGE function - based on a textstring

_____How to show a new line in a cell (wrap text)

_____Identify numbers stored as text

_____Highlight numbers stored as text

_____Example 1 - TEXT function

_____Example 2 - TEXT function

2023. Excel 'text manipulation' functions

2024. Excel text functions

_____MIN function ignore text

_____Count cells containing text from list

_____Count cells with text

_____Count specific multiple text strings in a given cell range

_____Count a specific text string in a cell (case sensitive)

_____Count text string in a range (case sensitive)

_____How to average a column containing some text values

_____SUMPRODUCT if cell contains text

2025. Formula not working - Number stored as text

2026. Formula not working - formula cell formatted as text

_____INDEX MATCH - partial text multiple conditions Excel 365

_____If cell contains text from list

_____Check if the cell contains text in the list

_____Display matches if cell contains text from list (Excel 2019)

_____Display matches if cell contains text from list (Earlier Excel versions)

_____Check if cell contains text in the list and return the corresponding value

_____If cell contains text

_____OR function contains text

2027. AND function with text

_____How to extract the year from a text string

_____Extract year when the date is located at the end of the text string

_____Extract year when the date is located somewhere in the middle of the text string

_____Extract year when the date is located at the beginning of the text string

_____Year as text

2028. How to use the TEXT function

2029. How to create your own custom formatting - TEXT function

2030. Formatting codes you can use in the TEXT function

_____How to use text in the TEXT function - @ at character

2031. Why isn't the TEXT function working?

2032. How to round numbers using the TEXT function

_____How to hide specific values - TEXT function

_____How to hide text values

_____How to sum a column with text (SUM function)?

_____Sum cells containing numbers and text based on a condition

_____VLOOKUP part of text

_____How to use the TEXTJOIN function

_____TEXTJOIN function - how to add row delimiting characters

_____Workaround for the TEXTSPLIT function - LAMBDA function

_____Reverse text

_____Cell range contains numbers, text, and blanks?

_____SMALL function for text

_____What happens if a text string is used in the logical expression?

_____How to check if a cell is a text value?

_____IF function - contains any text

_____Example 3 - Count cells containing a text string - partial match (wildcard)

_____Highlight text values

_____Highlight records containing text strings - AND Logic

_____Extract unique distinct text values containing string in a range

_____Extract unique distinct values if adjacent cell is text

_____A Comprehensive Guide to Splitting Text in Excel

_____Searching for the first characters in a text string [Array Formula]

_____Match a range value containing both text and numerical characters

_____Filtering unique distinct text values and sorting them based on the sum of adjacent values and criteria - earlier Excel versions

_____Filtering unique distinct text values and sorting them based on the sum of adjacent values and criteria - Excel 365

_____Search for a text string in a data set and return multiple records

_____Search for a text string in a data set and return multiple records [Array formula]

_____Search for a text string in a data set and return multiple records [Excel 365]

_____Search for a text string in a data set and return multiple records [Excel defined Table]

_____Search for a text string in a data set and return multiple records [Advanced Filter]

_____Sort text cells alphabetically from two columns

_____Sort text from two columns combined (array formula)

_____Merge and then sort text from two columns combined (array formula)

_____Create a unique distinct sorted list containing both numbers and text removing blanks with a condition - earlier Excel versions

_____Create a unique distinct sorted list containing both numbers and text removing blanks with a condition - Excel 365

_____Create unique distinct list sorted based on text length

_____Sort text values by length

_____Extract unique distinct text values containing string in a range - Excel 365

Time

_____Date and Time Functions – N to Z

2033. How to use the TIME function

2034. How to use the TIMEVALUE function

2035. What is time in Excel?

2036. TIME Function example

_____TIME function - how to add hours

_____TIME function - how to add minutes

_____TIME function - how to add seconds

_____Convert time to 24 hour clock

_____Date and Time Functions – A to M

2037. What is an Excel time value?

_____Count complete hours between two time values

_____Count complete hours between two date and time values

_____Watch schedule that populates vacation time

_____CONCAT function and date and time values

2038. Calculate time between time zones

_____How to use the TIMEVALUE function

_____How to round time to the nearest hour?

_____How to round time to the nearest quarter of an hour?

_____Random time values

_____What is an Excel time value?

_____Count complete hours between two time values

_____Count complete hours between two date and time values

_____Split date from a date and time value

_____Split time from a date and time value

_____Extract the hour from a time value

_____How to use the TIME function

_____What is time in Excel?

_____TIME Function example

_____TIME function - how to add hours

_____TIME function - how to add minutes

_____TIME function - how to add seconds

_____Convert time to 24 hour clock

_____How to AVERAGE time

_____How to sum overlapping time

_____How to calculate overlapping time ranges

_____Count entries based on date and time

_____Count how many times a string exists in a cell range (case insensitive)

2039. Time formats

2040. Time sheet for work

2041. How I built this time tracker

_____Create monthly time sheet using a Pivot Table

2042. One time pad cipher

_____Highlight specific time ranges in a weekly schedule

_____Match a date when date ranges sometimes overlap and return multiple results

Unique

_____Sort unique values in random order

2043. How to use the UNIQUE function

2044. UNIQUE Function example

2045. Unique values

_____Extract unique values

_____Extract unique values sorted from A to Z

_____Extract unique values ignoring blanks

_____Extract unique values sorted from A to Z ignoring blanks

_____Unique rows

_____Extract unique rows

_____Extract unique rows ignoring blank rows

_____Extract unique rows sorted from A to Z ignoring blank rows

_____Unique columns

_____Highlight unique/duplicates

_____How to rank text uniquely without duplicates

_____How to rank uniquely based on a condition

_____Test if a data set has a unique mode or multiple modes?

_____Assign records unique random text strings

_____Find smallest and largest unique number

_____How to extract a case sensitive unique list from a column

_____Extract a case sensitive unique list from a column

_____Extract a case sensitive unique list from a column - Excel 365

_____Sum unique numbers

_____VLOOKUP unique

_____Rotating unique groups with no repeat

_____Highlight unique values in a filtered Excel table

_____Highlight unique rows (COUNTIFS function)

_____Filter unique rows case sensitive - Excel 365 LAMBDA function

_____Compare two lists and filter unique values where the sum in one column doesn't match the other column

_____Count unique values

_____Count unique values (case sensitive)

2046. Working with unique values

_____Extract unique values from two columns - Excel 365

_____Extract unique values from two columns - earlier Excel versions

_____Filter unique values and sort based on adjacent date - Excel 365

_____Filter unique values from a cell range - all Excel versions

_____Filter unique values sorted from A to Z

_____Find min and max unique and duplicate numerical values

_____Filter unique strings from a cell range

_____Filter unique strings in a range - Excel 365

_____How to filter unique values from a list [Formula]

_____Highlight unique values [Conditional Formatting]

Vlookup

_____Partial match VLOOKUP - asterisk character (wildcard)

_____Column function and VLOOKUP

_____CHOOSE function with VLOOKUP

_____How to use the VLOOKUP function

_____VLOOKUP function formula

_____VLOOKUP - approximate match

_____Merge two data sets using the VLOOKUP function

_____VLOOKUP - how to use multiple tables

_____VLOOKUP - What if the lookup value is not in the leftmost column?

_____How to handle VLOOKUP errors

_____Using multiple criteria in VLOOKUP

_____VLOOKUP function - Partial match using wildcards

_____VLOOKUP function - Partial match - begins with

_____VLOOKUP function - Partial match - ends with

_____VLOOKUP function - Partial match - contains

_____VLOOKUP function - Partial match - question mark

_____VLOOKUP function - tilde character escapes wildcard characters

_____VLOOKUP - Duplicate repeated values

_____VLOOKUP and HLOOKUP together

_____VLOOKUP - can't find a value that is there

_____VLOOKUP alternatives

_____VLOOKUP just shows the formula

_____VLOOKUP another sheet

_____VLOOKUP keep formatting

_____VLOOKUP backward - lookup from bottom to top

_____VLOOKUP on two columns

_____VLOOKUP between dates

_____VLOOKUP returns #N/A

_____VLOOKUP yes if true

_____VLOOKUP part of text

_____VLOOKUP vs INDEX MATCH

_____VLOOKUP returns multiple columns

_____VLOOKUP zero if not found

_____VLOOKUP sum

_____VLOOKUP true false

_____VLOOKUP unique

_____Use VLOOKUP to calculate discounts, commissions, tariffs, charges, shipping costs, packaging expenses or bonuses

_____How to VLOOKUP using the INDIRECT function?

_____How to join data sets using the VLOOKUP function

_____Can you replace the VLOOKUP function with the INDEX function?

_____Where do I use the INDEX - MATCH functions instead of VLOOKUP?

_____How to use VLOOKUP/XLOOKUP with multiple conditions

_____VLOOKUP function with two conditions applied to two columns (AND logic)?

_____VLOOKUP function with two conditions applied to two columns (OR logic)?

_____VLOOKUP function with many conditions applied to one column (OR logic)?

_____Can we use VLOOKUP with multiple lookup values?

_____VLOOKUP across multiple columns?

_____Can you concatenate VLOOKUP results?

_____How to use VLOOKUP with dates?

_____VLOOKUP - Select column using a drop-down list

_____VLOOKUP in a filtered Excel Table and return multiple values

_____VLOOKUP – Return multiple unique distinct values

_____VLOOKUP - Return multiple unique distinct values

_____VLOOKUP - Return multiple unique distinct values (Excel 365)

_____Fuzzy VLOOKUP

_____Fuzzy VLOOKUP - Excel 365 LAMBDA function

_____Fuzzy VLOOKUP - array formula

_____If value in range then return value - VLOOKUP function

_____Use VLOOKUP to search date in date ranges and return value on the same row

_____5 easy ways to VLOOKUP and return multiple values

_____VLOOKUP - Return multiple values [vertically]

_____VLOOKUP and return multiple values - case sensitive

_____VLOOKUP and return multiple values - if not equal to

_____VLOOKUP and return multiple values - if smaller than

_____VLOOKUP and return multiple values - if larger than

_____VLOOKUP and return multiple values - if contains

_____VLOOKUP and return multiple values - if not contain

_____VLOOKUP and return multiple values - that begins with

_____VLOOKUP and return multiple values - that ends with

_____How to count VLOOKUP results

_____VLOOKUP - Return multiple values [horizontally]

_____VLOOKUP - Extract multiple records based on a condition

_____VLOOKUP with 2 or more lookup criteria and return multiple matches

_____Vlookup with multiple matches returns a different value

_____Vlookup across multiple sheets

_____VLOOKUP a cell range and return multiple values

_____VLOOKUP and return multiple values across columns

_____Return multiple matches with wildcard VLOOKUP

Week

_____Example 7 - create totals by year and week

_____How to use the WEEKDAY function

2047. How to use the WEEKNUM function

_____Create a list of weekdays only

_____Count weekdays in a month

_____WEEKDAY Function Video

_____WEEKDAY Function example

_____WEEKDAY Function not working

_____WEEKDAY function - show weekday name

_____WEEKDAYS between dates

_____How to calculate a date based on specific weekday in a month

2048. WEEKNUM function example 1

_____Extract week ranges based on a given date range

2049. WEEKNUM function not working

2050. Year by week?

_____The year begins on what weekday?

_____Calculate date given weekday and week number (week starts on Sunday)

_____Calculate date given weekday and week number (week starts on Monday)

_____How to get weekly historical stock prices

_____Example 10 - sequence of weeks

_____Sort by week number

_____Highlight a row if the date is last week

_____Highlight a row if the date is in this week

_____Highlight a row if the date is in next week

_____How to use the WEEKNUM function

_____WEEKNUM function example 1

_____Extract week ranges based on a given date range

_____WEEKNUM function not working

_____How to round a date to the nearest given weekday?

_____How to round a date to the nearest upcoming weekday?

_____Calculate the number of weeks between given dates

_____Calculate the number of weeks and days between given dates

_____Calculate the number of weeks and days between given dates - dynamic text values

_____Create a list of weekdays only

_____Count weekdays in a month

_____How to use the WEEKDAY function

_____Example 2 - show weekday name

_____Example 3 - Weekdays between dates

_____How to calculate a date based on specific weekday in a month

_____How do I sum values between n-th weekday this month and n-th weekday next month?

_____Year by week?

_____The year begins on what weekday?

_____Calculate date given weekday and week number (week starts on Sunday)

_____Calculate date given weekday and week number (week starts on Monday)

_____How to sum values by week?

_____Highlight weekends

_____Weekly schedule template

_____Setting up your work hours in a weekly schedule

_____Highlight specific time ranges in a weekly schedule

_____Weekly appointment calendar

_____Populate cells dynamically in a weekly schedule

_____Find empty hours in a weekly schedule

_____Filter duplicates within same date, week or month

_____7 days (weekly) date ranges using a formula

_____Count unique distinct values within same week, month or year

_____Highlight duplicates with same date, week or month

_____How to highlight weekends

_____How to highlight dates based on day of week

Year

_____Example 4 - create totals by year

_____Example 5 - aggregate by year and month

_____Example 6 - summarize by year and quarter

_____Example 7 - create totals by year and week

2051. How to use the YEAR function

2052. How to use the YEARFRAC function

2053. YEAR function example

_____Calculate year from date?

_____How to extract the year from a text string

_____Extract year when the date is located at the end of the text string

_____Extract year when the date is located somewhere in the middle of the text string

_____Extract year when the date is located at the beginning of the text string

2054. YEAR function not working?

_____YEAR function returns #NAME! error

_____YEAR function returns #VALUE! error

_____YEAR function returns #NUM! error

_____How to calculate years between dates?

_____How to convert year to a date?

_____Year and month

2055. Year and quarter

_____Year as text

_____Year and month to date?

_____Year by week?

_____The year begins on what weekday?

_____DATEDIF function example - calculate complete years between two dates

_____Calculate days between two dates ignoring the years

_____Extract unique distinct year and months from dates

_____How to use the YEARFRAC function

_____Heat map yearly calendar

_____DATEDIF function example - calculate complete years between two dates

_____Calculate days between two dates ignoring the years

_____How to use the YEAR function

_____YEAR function example

_____Calculate year from date?

_____How to extract the year from a text string

_____Extract year when the date is located at the end of the text string

_____Extract year when the date is located somewhere in the middle of the text string

_____Extract year when the date is located at the beginning of the text string

_____YEAR function not working?

_____YEAR function returns #NAME! error

_____YEAR function returns #VALUE! error

_____YEAR function returns #NUM! error

_____How to calculate years between dates?

_____How to convert year to a date?

_____Year and month

_____Year and quarter

_____Year as text

_____Year and month to date?

_____Year by week?

_____The year begins on what weekday?

_____How to sum values by year?

_____Highlight events in a yearly calendar

_____Remove duplicates within same month or year

_____Create a number sequence to count records by year and month (sorted list)

_____Create a number sequence to count records by year and month (unsorted list)

_____Create a number sequence to count dates based on year

_____Create a number sequence to count records by individual products and years

_____Count unique distinct values within same week, month or year

_____List all unique distinct rows in a given month and year

_____List all unique distinct rows in a given month and year (Excel 365)

_____List all rows in a given month and year

_____List all rows in a given month and year (Excel 365)

Excel formula examples

#, hashtag

2D, two-dimensional, two-way

3D, multiple worksheets, multiple sheets

365

Address

Advanced Filter

Alternative

And logic

Autofilter

Average

Blank, space

Calendar

Case

Character

Column

Combination, combin

Complex, imaginary

Concatenate, combine, merge, join, append

Conditional formatting, cf, highlight

Count

Countif

Countifs

Criteria, multiple conditions, conditions

Date

Day

Decimal

Delete, remove

Digit

Duplicates

Dynamic

Empty

Equal, condition, criterion

Error, problem

Extend, expand

Extract, list, filter, get

Finance, stock, expense

First, last

Group, category

Hour

Hyperlink, link

If

Ifs

Ignore, avoid, prevent, exclude, hide

Image, picture

Index

Index match, index and match

Intersection

Lambda

Large, larger, highest, greater

Letter

Lookup, find, identify

Match

Max

Min

Minute

Month

Multiply, multiplication, product

Negative, minus, subtract

New line

Not equal

Or logic

Overlapping

Partial, wildcard, contain

Permut

Random

Rearrange, distribute

Record, row

Recursive

Reference

Relation, related

Reverse

Right, left

Running total

Schedule

Second

Sequence, consecutive

Shared, common, exist, occur

Small, smaller, less

Solver