## 'VSTACK function' category

Array Manipulation Functions

Table of Contents How to use the CHOOSECOLS function How to use the CHOOSEROWS function How to use the DROP […]

Table of Contents How to use the CHOOSECOLS function How to use the CHOOSEROWS function How to use the DROP […]

Multiply numbers in each row by entire cell range

This article demonstrates a recursive LAMBDA function and a User Defined Function (UDF) that multiplies numbers in each row with […]

This article demonstrates a recursive LAMBDA function and a User Defined Function (UDF) that multiplies numbers in each row with […]

Working with classic ciphers in Excel

What's on this page Reverse text Insert random characters Convert letters to numbers How to shuffle characters in the alphabet […]

What's on this page Reverse text Insert random characters Convert letters to numbers How to shuffle characters in the alphabet […]

Compare two columns and extract differences

This article demonstrates formulas that extract values that exist only in one column out of two columns. There are text […]

This article demonstrates formulas that extract values that exist only in one column out of two columns. There are text […]

Group rows based on a condition

What's on this page Group rows based on a condition Merge matching rows 1. Group rows based on a condition […]

What's on this page Group rows based on a condition Merge matching rows 1. Group rows based on a condition […]

Filter unique distinct records case sensitive

This article demonstrates two ways to extract unique and unique distinct rows from a given cell range. The first one […]

This article demonstrates two ways to extract unique and unique distinct rows from a given cell range. The first one […]

Analyze word frequency in a cell range

This article demonstrates two ways to calculate the number of times each word appears in a given range of cells. […]

This article demonstrates two ways to calculate the number of times each word appears in a given range of cells. […]

Filter strings containing a given substring in a cell range

This post describes ways to extract all matching strings from cells in a given cell range if they contain a […]

This post describes ways to extract all matching strings from cells in a given cell range if they contain a […]

Convert date ranges into dates

This article demonstrates how to create a list of dates based on multiple date ranges. Table of contents Convert date […]

This article demonstrates how to create a list of dates based on multiple date ranges. Table of contents Convert date […]

Merge two columns with possible blank cells

This article demonstrates two formulas, they both accomplish the same thing. The Excel 365 formula is much smaller and is […]

This article demonstrates two formulas, they both accomplish the same thing. The Excel 365 formula is much smaller and is […]

Find the most recent date that meets a particular condition

This article demonstrates how to return the latest date based on a condition using formulas or a Pivot Table. The […]

This article demonstrates how to return the latest date based on a condition using formulas or a Pivot Table. The […]

Merge cell ranges into one list

The above image demonstrates a formula that adds values in three different columns into one column. Table of Contents Merge […]

The above image demonstrates a formula that adds values in three different columns into one column. Table of Contents Merge […]

Extract a list of duplicates from a column

The array formula in cell C2 extracts duplicate values from column A. Only one duplicate of each value is displayed […]

The array formula in cell C2 extracts duplicate values from column A. Only one duplicate of each value is displayed […]

Find missing numbers

Table of Contents Find missing numbers in a column based on a given range Find missing three character alpha code […]

Table of Contents Find missing numbers in a column based on a given range Find missing three character alpha code […]

Working with unique values

What's on this page Extract unique values from two columns - Excel 365 Extract unique values from two columns - […]

What's on this page Extract unique values from two columns - Excel 365 Extract unique values from two columns - […]

Filter unique distinct records

Table of contents Filter unique distinct row records Filter unique distinct row records but not blanks Filter unique distinct row […]

Table of contents Filter unique distinct row records Filter unique distinct row records but not blanks Filter unique distinct row […]

## Excel formula categories

AverageChooseCombine MergeCompareConcatenateConditional FormattingCountCount valuesDatesDuplicatesExtractFilterFilter recordsFiltered valuesFilterxmlHyperlinkIf cellIndex MatchLogicLookupsMatchMaxMinNumbers in sumOR logicOverlappingPartial matchRecordsSequenceSmallSort bySort valuesSumSumifsSumproductString manipulationTimeUnique distinct recordsUnique distinct valuesUnique recordsUnique valuesVlookupVlookup return values