## 'VSTACK function' category

Workaround for the TEXTSPLIT function – LAMBDA function

The TEXTSPLIT function works only with single cells. If you try to use a cell range the TEXTSPLIT function returns […]

The TEXTSPLIT function works only with single cells. If you try to use a cell range the TEXTSPLIT function returns […]

How to use the VSTACK function

The VSTACK function lets you combine cell ranges or arrays, it joins data to the first blank cell at the […]

The VSTACK function lets you combine cell ranges or arrays, it joins data to the first blank cell at the […]

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 […]

SUMIF across multiple sheets

This post describes two ways to a search multiple ranges and calculate a total of the corresponding values across worksheets […]

This post describes two ways to a search multiple ranges and calculate a total of the corresponding values across worksheets […]

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 words containing a given string in a cell range

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

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

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 two columns

The picture above shows how to merge two columns into one list using a formula. Table of Contents Merge two […]

The picture above shows how to merge two columns into one list using a formula. Table of Contents Merge two […]

Merge three columns 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 […]

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