Excel formula examples

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

1376. IF

1377. IF function example

_____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 if a date is later than a given condition

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

_____What if the lookup value is not in the leftmost column?

1378. Yes if true

1379. Zero if not found

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

1380. Bifid

1381. Trifid

_____Update list with new values if possible

1382. Modify Scroll Bar settings

1383. Nested IF functions

_____If not blank

1384. If not NA

_____If not error

1385. How to simplify IF functions

1386. If greater than 0 (zero)

_____If between two dates

_____If cell contains text

1387. If or

1388. How to use the IF function

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

1390. 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

_____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

1391. 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

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

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

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

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

1396. Return multiple values if in range

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

1398. VLOOKUP and return multiple values - if smaller than

1399. VLOOKUP and return multiple values - if larger than

1400. VLOOKUP and return multiple values - if contains

1401. VLOOKUP and return multiple values - if not contain

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

_____Macro deletes entire row if the formula returns blanks

Ifs

1403. How to use the MINIFS function

1404. How to use the IFS function

1405. How to use the MAXIFS function

_____How to use the AVERAGEIFS function

1406. How to use the SUMIFS function

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

_____How to use the COUNTIFS function

_____Highlight unique rows (COUNTIFS function)

Ignore, avoid, prevent, exclude, hide

_____Example - exclude columns

_____Example - exclude columns and rows

_____Ignore #N/A error

1407. What values are excluded from the calculation?

1408. Which values are excluded in the calculation?

1409. What will the function not exclude?

1410. Does the function ignore cell formatting?

1411. Example 2 - ignore 0 (zero)

_____Example 4 - ignore errors

1412. Example 5 - ignore negative numbers

1413. Example 6 - ignore text

_____Example 7 - ignore #NA error

1414. Are boolean values ignored?

1415. Exclude some cells

_____Example - ignore blanks

1416. Example - ignore NA()

_____Does the SUBTOTAL function avoid double counting?

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

_____Hashtag character lets you hide extra zeros

1418. How to hide specific values

1419. How to hide positive numbers

1420. How to hide negative numbers

1421. How to hide zeros

1422. How to hide text values

_____How to ignore errors

1423. 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

1424. Prevent duplicate records in a worksheet

_____How to ignore error values

1425. How to ignore zeros

_____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

1426. How to use the IMAGE function

_____Show an image based on a drop-down list

_____Show / hide a picture using a button

1427. Insert an image

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

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

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

1431. Heat map using pictures

Index

1432. Horizontal and vertical lookup - INDEX + MATCH

1433. How to use the INDEX function

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

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

1436. Two index table

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

_____If value in range then return value - INDEX + MATCH

Index match, index and match

1438. INDEX MATCH – multiple results

1439. 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

1440. INDEX MATCH

_____Merge data using the INDEX and MATCH functions

_____INDEX MATCH

_____INDEX MATCH - Excel 365

Intersection

1441. Calculate the intersection of two cell ranges

Lambda

1442. How to use the LAMBDA function

_____Substitute multiple text strings - Excel 365 recursive LAMBDA function

1443. 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?

1444. How to sort from smallest to largest?

1445. How to sort from largest to smallest?

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

_____If larger than

1447. Example 4 - 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

_____How to convert large decimal numbers to binary?

1448. 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

1449. Second highest

_____Second-highest number no duplicates

_____Second-highest number based on a condition

_____Get the highest number within each row

1450. 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

_____Extract the largest number ignoring error values

_____Extract the largest number ignoring error values using arrays

1451. How to use the LARGE function

_____Example 7 - calculate an average based on the three largest numbers

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

1452. Find smallest and largest unique number

1453. Larger than

_____How to extract the largest number ignoring error values

_____Hour value larger than 24

1454. Minutes value larger than 59

1455. Seconds value larger than 59

1456. Example 1 - greater than

_____How to extract the largest number from filtered data?

_____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

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

1457. Add 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

_____If greater than 0 (zero)

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

1458. Greater than

_____Example 2 - Count cells larger/less than a criterion

1459. Partial match and return value with highest level

_____VLOOKUP and return multiple values - if larger than

Letter

1460. Example 12 - sequence of letters

1461. Does the function differentiate between upper and lower letters?

_____Sort by the first letter/digit?

_____Sort by the first letter - Example 2

1462. 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

1463. 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

1464. 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

1465. Convert letters to numbers

Lookup, find, identify

_____Two-way lookup using multiple tables

_____Partial match VLOOKUP - asterisk character (wildcard)

1466. How to use the XLOOKUP function

1467. How to perform a binary xlookup

1468. 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

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

1470. How to use the FIND function

1471. Example 3 - find the element name based on an atomic number

1472. Find the optimal permutation - Excel Solver

_____Find smallest and largest unique number

1473. How to find out which formatting a specific cell has

_____How to identify a new line character in an Excel formula

1474. VLOOKUP

1475. Identify numbers stored as text

_____Identify digits in a string

1476. MID function with FIND function

1477. VLOOKUP and CHOOSE

_____Find the last non-empty cell with short cut keys

1478. Find the closest value

_____Find closest value - Excel 365

1479. Find closest values

1480. Find closest values and return adjacent values

_____Find closest value with a criterion

1481. Locate lookup values in an Excel table

1482. How to use the HLOOKUP function

1483. Horizontal and vertical lookup

_____Horizontal and vertical lookup - INDEX + MATCH

1484. How to use the VLOOKUP function

_____What if the lookup value is not in the leftmost column?

1485. HLOOKUP

1486. Can't find a value that is there

1487. Backwards - lookup from bottom to top

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

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

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

1489. 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

1490. How to identify array formulas?

_____Find most overlapped date range

_____Find empty dates in a set of date ranges

1491. 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

1492. How to use the LOOKUP function

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

1493. Nested LOOKUP functions

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

_____Find last matching value in an unsorted list

_____Lookup and match last value - reverse lookup

1495. VLOOKUP and INDIRECT function

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

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

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

1499. Find multiple sequences with any value between?

1500. Lookup for a multi-level sequence

1501. Lookup for multiple multi-level sequences

1502. Finding the shortest path – A * pathfinding

_____How to join data sets using the VLOOKUP function

1503. Identify rows of overlapping records

_____Identify rows of overlapping records - Excel 365

1504. 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

_____Example 6 - return an array identifying records based on multiple conditions

1505. Lookup_array in ascending order

1506. Lookup_array in any order

1507. 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)?

1508. 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)?

1509. 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

1510. Find numbers in close proximity to a given number

_____Highlight lookup values

1511. VLOOKUP – Return multiple unique distinct values

1512. VLOOKUP - Return multiple unique distinct values

_____VLOOKUP - Return multiple unique distinct values (Excel 365)

1513. Find lower prices

1514. Find higher prices

1515. Fuzzy VLOOKUP

_____Fuzzy VLOOKUP - Excel 365 LAMBDA function

1516. 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

1517. Identify numbers in sum using Excel solver

1518. 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

1519. 5 easy ways to VLOOKUP and return multiple values

1520. 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

1521. VLOOKUP and return multiple values - that begins with

1522. VLOOKUP and return multiple values - that ends with

_____How to count VLOOKUP results

1523. 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]

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

_____VLOOKUP with 2 or more lookup criteria and return multiple matches

1525. Vlookup with multiple matches returns a different value

_____Lookup with multiple matches returns different values - Excel 365

_____Vlookup across multiple sheets

1526. 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

1527. 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

1528. Return multiple matches with wildcard VLOOKUP

1529. Find min and max unique and duplicate numerical values

_____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

1530. How to use the XMATCH 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 (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)

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

1532. Approximate match

_____Horizontal and vertical lookup - INDEX + MATCH

_____Approximate match

_____Count matching strings using regular expressions

1533. How to match phone numbers?

_____Find last matching value in an unsorted list

_____Lookup and match last value - reverse lookup

_____Exact match case sensitive

1534. How to use the MATCH function

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

_____Match cell that ends with the condition

_____Match cell that begins with the condition

1536. 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

1537. How to use the DMAX function

1538. How to use the MAX function

_____How to use the MAXIFS function

1539. Example 4 - MAX

_____Lookup min max values within a date range

_____How to highlight MAX and MIN value within a month

_____Find min and max unique and duplicate numerical values

Min

_____Calculate the complex determinant of a 2x2 matrix

_____How to use the MINIFS function

1540. How to use the MINA function

1541. How to use the MINVERSE function

1542. How to use the DMIN function

_____How to round a date to the nearest upcoming weekday?

_____Example 2 - filter the upcoming dates for next week

1543. How to use the MINUTE function

1544. Example 5 - MIN

_____Minutes value larger than 59

1545. How to add minutes

1546. How to use the MIN function

_____Use price ranges to determine discount

1547. Bill reminder in excel

_____Lookup min max values within a date range

_____How to highlight MAX and MIN value within a month

_____Find min and max unique and duplicate numerical values

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

Minute

_____How to use the MINUTE function

_____Minutes value larger than 59

_____How to add minutes

Month

1548. Example 5 - aggregate by year and month

_____How to get historical monthly stock prices

1549. Example 9 - sequence of months

1550. 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

1551. How to use the EOMONTH function

_____Calculate quarterly dates for the last day of a given month

_____Calculate bi monthly dates for the last day of a given month

1552. EOMONTH function tips

1553. EOMONTH function not working

_____EOMONTH function alternative

_____Calculate bi-monthly dates

_____Calculate complete months between two dates

1554. Example 2 - convert month number to month name

_____Count weekdays in a month

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

1555. How to use the MONTH function

_____MONTH function alternative

1556. 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

1557. By month

1558. Year and month

_____Year and month to date?

_____Example 2 - add or subtract months and days

1559. Add months

_____Last day of a given month

1560. Add values by month

1561. Create monthly time sheet using a Pivot Table

1562. 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)

_____Filter duplicates within same date, week or month

_____Create a monthly date range

_____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

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

_____Multiply complex number by i

1563. How to multiply numbers in an Excel formula

1564. How to multiply a number and cell value

1565. How to multiply cell values

1566. How to multiply multiple cell values

1567. How to multiply values using an Excel function

1568. How to multiply functions in an Excel formula

_____How to multiply boolean values - apply AND logic

1569. Multiply numbers in each row by entire cell range

1570. How to use the DPRODUCT function

1571. How to use the PRODUCT function

1572. Example 6 - PRODUCT

1573. How to use the SUMPRODUCT function

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

Negative, minus, subtract

_____How to enter negative complex numbers in Excel

_____How to combine columns using negative values - Excel 365

1574. 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 negative numbers

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

1576. How to convert all numbers to negative numbers?

1577. Convert negative numbers to positive and calculate the sum

_____Convert negative numbers to positive and calculate the average

1578. Convert negative numbers to positive and calculate the median

_____Example 5 - ignore negative numbers

_____Example 2 - add or subtract months and days

_____Subtract days

1579. How to convert negative numbers to positive numbers?

1580. How to convert positive numbers to negative numbers?

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

1582. 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

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

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

Not equal

_____If not equal to

1585. Not equal to

_____Case sensitive condition not equal to

1586. Example 2 - not equal

1587. How to sum not equal to

1588. Not equal

_____VLOOKUP and return multiple values - if not equal to

Or logic

_____Based on a condition per column - OR logic

1589. Example 4 - OR logic

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

_____How to filter using OR logic between columns - Advanced Filter

1590. How to use OR logic

1591. Example 7 - 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

1592. How to sum overlapping time

1593. 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

_____If contains

_____If not contain

_____Highlight cells containing string

_____Extract records containing negative numbers

1594. 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

_____Example 2 - wildcard characters

1595. Contains

_____How to use wildcard characters

_____Contains

1596. Wildcard

1597. Example 5 - partial match

_____Count cells containing text from list

_____Column containing some text values

_____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

1598. Contains text

_____How to select a cell containing a hyperlink?

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

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

_____Add cells containing numbers and text based on a condition

1599. Partial match using wildcards

1600. Partial match - begins with

1601. Partial match - ends with

1602. Partial match - contains

1603. Partial match - question mark

_____Tilde character escapes wildcard characters

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

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

1605. Wildcard search for a sequence

1606. 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

_____If cell contains text

_____Wildcard characters

_____Cell range contains numbers, text, and blanks?

_____Example 2 - Partial match using wildcard characters

_____Cell contains an error

_____Contains

1607. Contains any text

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

_____How to use this 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

1608. Partial match and return multiple adjacent values

1609. 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

1610. 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

_____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 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

_____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

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

_____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

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

1611. How to select cells containing data

Permut

1612. How to use the PERMUTATIONA function

_____Create a list of permutations - Excel 365

_____List permutations with repetition and how many to choose from

_____List all permutations with a condition

1613. How to use the PERMUT function

_____Permutations without repetition - Excel 365 formula

_____Find the optimal permutation - Excel Solver

1614. How to create permutations

1615. Permutations with repetition

1616. Constructing a permutations array with binary values

1617. Permutations without repetition

Random

1618. Example - values in random order

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

1619. Example - values in random order

1620. Example 3 - values in random order

_____Example - values in random order

1621. Sort in random order

1622. Sort unique values in random order

_____Random numbers with a decimal

_____Random negative numbers with two decimals

_____Random negative numbers with three decimals

1623. Random names

_____Random list

1624. Create random text strings

1625. Random numbers

1626. Random text strings

_____Random date values

1627. Random time values

1628. 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

1629. Search values distributed horizontally and return corresponding values

_____Filter values distributed horizontally - Excel 365

1630. Rearrange values using formulas

1631. Rearrange data

_____Rearrange values in a cell range to a single column

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

1633. Rearrange values

1634. Distribute values across numerical ranges

Record, row

1635. How to use the BYROW function

_____Count the top 10 numbers in a cell range per row

_____Count the bottom 10 numbers in a cell range per row

_____Count the top 10 numbers in a cell range (column-wise) per row

_____Multiply numbers in each row by entire cell range

1636. How to use the CHOOSEROWS function

_____CHOOSEROWS Function errors

_____Get every other row

_____Example - exclude columns and rows

_____Example - return columns and rows

1637. How to use the WRAPROWS function

1638. How to use the TOROW function

_____TOROW Function alternative

_____Extract unique distinct rows from multiple cell ranges

_____How to create a string containing column and row delimiting characters

_____Example 3 - How to calculate the relative position of column and row

_____Sort based on row count

1639. Sort based on frequency row-wise

1640. 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

1641. 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?

1642. Sort rows based on the geometric mean

_____How to copy every n-th row from a list

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

1644. Sort rows by the variance of a population

1645. Sort rows by standard deviation of a sample

_____Extract records containing negative numbers

1646. 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

1647. How to use the ROWS function

_____Count rows in an array

_____Count rows based on a condition

_____Count rows based on a list

_____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 - 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 (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

1648. A row

1649. Add values a given row using a formula

1650. How to add a row

_____How to delete an Excel Table row

1651. Reference a value on the same row

_____Extract rows where any cell is equal to a condition

1652. How to add fields to Pivot Table Row Labels

_____Extract unique distinct records

_____Row and column grand totals

_____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

_____Prevent duplicate records in a worksheet

_____Sort rows based on count and criteria - Excel 365

_____Sort rows based on count and criteria - earlier versions

_____Example 1 - cell ranges with an equal number of rows and columns

_____Example 2 - cell ranges with different number of rows and columns

_____Example 3 - cell ranges with different numbers of rows and columns

1653. Example 4 - calculate totals row-wise

_____SMALL and ROWS functions combined

1654. How to use the ROW function

1655. Number rows in any cell range

1656. How to number rows

_____Example 5 - Count duplicate records

_____Example 6 - 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

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

1657. How to return the entire row in a given cell range

_____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

1658. 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

1659. 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

1660. 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

_____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]

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

1662. 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]

1663. 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)

1664. Example 2 - 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

_____Macro deletes entire row if the formula returns blanks

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

1665. IMTAN function example 2 - cell reference

_____HSTACK function with 3D cell references

_____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

1666. How do structured references work?

1667. Reference an entire Excel Table

1668. Reference Excel Table data

_____Reference column headers

_____Reference a column

_____Reference a value on the same row

_____Extract cell references from a formula

1669. How to use cell references in array formulas?

1670. How to use absolute and relative references

1671. How to create a cell reference?

1672. How to create a cell reference to a worksheet name?

1673. How to hardcode a cell reference?

1674. Working with cell references

_____How to build a dynamic cell reference

1675. 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

1676. Example 6 - Create a cell reference to a cell range

Relation, related

1677. Comparing related functions and techniques

1678. Comparing related functions

1679. Working with Relational Tables in Excel

1680. Search for values in a related table

_____Search for values in a related table - Excel 365

1681. Sum values in a related table

_____Sum values in a related table - Excel 365

_____Highlight lookups in relational tables

_____Merge two relational data sets

1682. Working with three relational tables

_____Extract unique distinct values from a relational table

Reverse

1683. Example 1 - reverse running total

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

_____Example 7 - reverse a list using the SEQUENCE function

_____Reverse characters in value

1684. Reverse running total

_____Lookup and match last value - reverse lookup

1685. 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

_____Mark each character in a value with a number from left - Excel 365

_____Example - how to extend an array up and left

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

1686. Example 5 - Search right to left

1687. Calculate the hypothenuse in a right triangle

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

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

1690. Substitute from right

1691. How to use the RIGHT function

1692. How to use the LEFT function

1693. 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

_____What if the lookup value is not in the leftmost column?

1694. 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

_____Example 1 - reverse running total

1695. Running total

_____Reverse running total

1696. 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

1697. 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

1698. Shift Schedule

1699. Watch schedule that populates vacation time

_____Schedule project dates based on a finish date

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

1701. 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

1702. Free School Schedule Template

_____Populate cells dynamically in a weekly schedule

_____Find empty hours in a weekly schedule

1703. Using Excel Solver to schedule employees

Second

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

1704. How to use the SECOND function

_____Seconds value larger than 59

1705. 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

1706. How to use the SEQUENCE function

1707. Example 3 - create a repeating sequence

1708. Example 4 - create repeated numbers in a sequence

_____Example 5 - create blanks in a sequence of numbers

1709. 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

1710. Example 10 - sequence of weeks

1711. Example 11 - sequence of quarters

_____Example 12 - sequence of letters

1712. Example 13 - sequence of cells?

_____Alternative to the SEQUENCE function?

1713. Create a horizontal sequence

1714. Search for a sequence of values

_____How to find a sequence with any value between?

_____Find multiple sequences with any value between?

_____Lookup for a multi-level sequence

_____Lookup for multiple multi-level sequences

_____Wildcard search for a sequence

_____Wildcard search for multiple sequences

_____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

1715. Create number sequences (Autofill)

1716. 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

_____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

_____Filter values in common between two multi-column cell ranges - Excel 365

_____Filter values in common between two multi-column cell ranges - Excel 2019

_____Filter values in common between two multi-column cell ranges - earlier versions

_____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

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

_____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

1717. Conditional operators - smaller than

_____Find smallest and largest unique number

1718. SMALL function

1719. Smaller than

_____How to extract the smallest number from filtered data?

_____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

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

_____Add values greater than smaller than

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

1720. How to use the SMALL function

_____SMALL and ROWS functions combined

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

_____Smaller than

_____Example 2 - Count cells larger/less than a criterion

_____VLOOKUP and return multiple values - if smaller than

_____Highlight the smallest duplicate number

Solver

1721. Solve linear equations using Solver

_____Test combinations (Solver)

_____Find the optimal permutation - Excel Solver

1722. 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

_____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

_____Sort in random order

1723. How to use the SORTBY function

1724. How to sort from A to Z?

1725. 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

_____Sort by the first letter/digit?

_____Sort by the first letter - Example 2

_____Sort by the first digit - Example 3

1726. Sort by absolute value?

_____Sort by the last word in a cell?

_____Sort by the first name?

_____Sort by the last name?

_____Sort by custom list?

_____Sort by month?

1727. Sort by word length

_____Sort in random order

_____Sort unique values in random order

1728. Sort by week number

1729. Sort by quarter

_____Sort based on row count

1730. Sort numbers based on proximity to a given number

_____Sort based on frequency row-wise

_____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)

1731. How to use the SORT function

_____Sort a multicolumn cell range

_____Sort letters and numbers?

_____Sort based on values in an adjacent column

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

_____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

1732. How to sort an Excel Table

1733. 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 column based on count

_____Sort rows based on count and criteria - Excel 365

_____Sort rows based on count and criteria - earlier versions

_____Lookup_array in ascending order

_____Lookup_array in descending order

1734. 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

_____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)

_____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

_____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

1735. Sort values using array formula

1736. 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

1737. Sort alphanumeric values

1738. Sort text values by length

_____Sort two columns

_____Sort records based on two columns

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

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

1740. 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

1741. Example - split text to array

1742. How to use the TEXTSPLIT function

_____Split string using multiple delimiting characters

_____How to split date value

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

1744. 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

_____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)

1745. 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)

1746. 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

1747. Åad 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

_____Example 3 - extract string between two substrings

_____Highlight cells containing string

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

1748. How to decode URL-encoded strings

1749. Return all positions of a given substring

_____Create random text strings

_____Random text strings

_____Assign records unique random text strings

_____Split string and remove decimals

1750. 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

1751. Example 6 - based on a textstring

_____How to convert comma delimiting numbers to a string of characters

1752. How to convert string to ANSI numbers

_____Identify digits in a string

1753. Substitute multiple strings

_____Substitute all letters with a given string

_____Substitute multiple text strings - Excel 365 recursive LAMBDA function

_____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

1754. Convert string to HEX

1755. Convert string to ASCII

1756. Convert string to Base64

1757. 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 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

_____Extract values between two given delimiting strings

_____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

_____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]

1758. Exact word in string

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

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

_____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

1759. How to use the REPLACE function

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

1760. How to use the SUBSTITUTE function

_____Substitute multiple strings

_____Substitute from right

_____Substitute all letters with a given string

1761. Substitute all numbers

1762. Substitute based on table

1763. How to substitute double quotes

1764. How to replace part of formula in all cells

_____Substitute multiple text strings - Excel 365 recursive LAMBDA function

_____Can you replace the VLOOKUP function with the INDEX function?

Subtotal

1765. How to use the SUBTOTAL function

_____Does the SUBTOTAL function avoid double counting?

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

_____How to exclude manually hidden values from the SUBTOTAL function?

1767. How to use the Subtotal tool

1768. Start the Subtotal tool

1769. Subtotals on multiple levels

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

1770. Example 4 - SUBTOTAL and OFFSET functions

Sum, total

_____Example 1 - create totals by category

1771. Example 3 - summarize by two categories

1772. Example 4 - create totals by year

1773. Example 6 - summarize by year and quarter

1774. Example 7 - create totals by year and week

_____Example 8 - create totals and count in the same column

_____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

1775. How to use the IMSUM function

1776. IMSUM function example

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

_____How to plot the sum of two complex numbers?

_____Example 1 - reverse running total

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

1777. Calculate total by tier and grand total

1778. Total and grand total by amount

1779. How to use the SUMXMY2 function

1780. How to use the SUMX2MY2 function

1781. How to use the SUMSQ function

_____Count total characters in multiple cell ranges combined

1782. 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

1783. How to use the SUM function

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

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

_____Running total

1785. Create a total by color

_____Reverse running total

1786. Add unique numbers and return a total

1787. Sum

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

1788. How to show Excel Table totals

1789. 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

1790. How to create a sum?

_____Remove totals

1791. Sum numerical ranges between two numbers

1792. Sum unique distinct invoices

_____Sum based on OR - AND logic

_____Find empty cells and sum cells above

1793. Sum based on daily currency rates

_____Example 4 - calculate totals row-wise

_____Example 5 - 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 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

1794. How to use the SUMIF function

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

1795. 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

Sumproduct

_____How to use the SUMPRODUCT function

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

Tab

1796. How to create a tab in an Excel formula

1797. Tabula recta

Table, excel table

_____Two-way lookup using multiple tables

_____Sort by multiple columns using an Excel Table

1798. 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

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

1800. 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

1801. Add values using an Excel defined Table

1802. Multiple tables

1803. 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

1804. How to use Excel Tables

1805. How to create an Excel Table

1806. How to name an Excel Table

1807. How to manipulate Excel Table data

1808. 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

1809. How to use a formula in an Excel Table

1810. 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

1811. Excel Table and slicers

1812. 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

1813. Populate combo box with values from a table

_____Extract unique distinct values from 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

_____Filter duplicates - Excel Table

_____Highlight duplicates in a filtered Excel Table

_____Filter rows using an Excel table based on a date range

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

Team, tournament

1815. 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

1816. Double round-robin tournament

1817. True round-robin tournament

1818. Team Generator

_____Dynamic team generator

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

Text

_____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

1820. How to use the VALUETOTEXT function

1821. How to use the ARRAYTOTEXT function

_____Example - split text to array

_____How to use the TEXTSPLIT function

1822. How to use the TEXTAFTER function

1823. 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

_____How to create a frequency table based on text values

_____Extract the most frequent text values

1824. How to use the FORMULATEXT function

1825. How to use the ISNONTEXT function

1826. How to use the ISTEXT function

_____Filter text values

_____If cell contains any text

1827. 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

1828. For text

_____Example 6 - 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

1829. Example 1 - TEXT function

_____Substitute multiple text strings - Excel 365 recursive LAMBDA function

1830. Excel 'text manipulation' functions

_____Example 6 - 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)

_____Column containing some text values

1831. Formula not working - Number stored as text

1832. 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

_____Contains text

1833. Working 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

1834. Year as text

1835. How to use the TEXT function

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

_____How to hide text values

_____A column with text

_____Add cells containing numbers and text based on a condition

1836. Part of text

_____How to use the TEXTJOIN function

_____Workaround for the TEXTSPLIT function - LAMBDA function

_____Reverse text

_____If cell contains text

_____Cell range contains numbers, text, and blanks?

_____For text

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

1837. Cell is a text value

_____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

_____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]

_____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

_____Watch schedule that populates vacation time

_____CONCAT function and date and time values

1838. Calculate time between time zones

1839. 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

1840. 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

1841. How to use the TIME function

1842. What is time in Excel?

_____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)

1843. Time formats

1844. Time sheet for work

_____Time sheet for work - alternative 1

_____Time sheet for work - Alternative 2

_____Create monthly time sheet using a Pivot Table

1845. 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

1846. How to use the UNIQUE function

1847. 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

_____Add unique numbers and return a total

1848. 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)

1849. 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

_____Extract a case sensitive unique list from a column

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

_____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)

_____VLOOKUP

_____VLOOKUP and CHOOSE

_____How to use the VLOOKUP function

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

_____VLOOKUP and 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 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

1850. How to use the WEEKNUM function

_____Extract week ranges based on a given date range

_____How to round a date to the nearest given weekday?

_____How to round a date to the nearest upcoming weekday?

_____Example 2 - filter the upcoming dates for next week

_____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?

1851. 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)

1852. Add values by week

_____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

_____Extract unique distinct year and months from dates

1853. How to use the YEARFRAC function

_____Heat map yearly calendar

_____Example 1 - calculate complete years between two dates

_____Calculate days between two dates ignoring the years

1854. How to use the YEAR function

_____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

_____How to calculate years between dates?

_____How to convert year to a date?

_____Year and month

1855. Year and quarter

_____Year as text

_____Year and month to date?

_____Year by week?

_____The year begins on what weekday?

1856. Add values by year

_____Remove duplicates within same month or year

_____Highlight events in a yearly calendar

_____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