## 'LAMBDA function' category

How to use the MAKEARRAY function

The MAKEARRAY function returns an array with a specific number of rows and columns calculated by applying a LAMBDA function. […]

The MAKEARRAY function returns an array with a specific number of rows and columns calculated by applying a LAMBDA function. […]

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 LAMBDA function

The LAMBDA function lets you build custom functions using only regular Excel functions, no VBA is needed. These custom functions […]

The LAMBDA function lets you build custom functions using only regular Excel functions, no VBA is needed. These custom functions […]

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

Substitute multiple text strings

The SUBSTITUTE and REPLACE functions can only handle one string, this article demonstrates two ways to handle more than one […]

The SUBSTITUTE and REPLACE functions can only handle one string, this article demonstrates two ways to handle more than one […]

Rearrange data

Sean asks: Sheet1A B C D 8 Country Europe 9 Lights 100 10 Type A 200 11 12 Country USA […]

Sean asks: Sheet1A B C D 8 Country Europe 9 Lights 100 10 Type A 200 11 12 Country USA […]

Two-way lookup in multiple cross reference tables simultaneously

This article describes two ways to perform lookups in multiple in multiple cross reference tables simultaneously. The first one being […]

This article describes two ways to perform lookups in multiple in multiple cross reference tables simultaneously. The first one being […]

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

Fuzzy lookups

In this post I will describe a basic user defined function with better search functionality than the array formula in […]

In this post I will describe a basic user defined function with better search functionality than the array formula in […]

Fuzzy VLOOKUP

This formula returns multiple values even if they are arranged differently or have minor misspellings compared to the lookup value.

This formula returns multiple values even if they are arranged differently or have minor misspellings compared to the lookup value.

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

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