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

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

How to replace part of formula in all cells

Table of Contents How to replace part of formula in all cells Substitute multiple text strings - Excel 365 recursive […]

Table of Contents How to replace part of formula in all cells Substitute multiple text strings - Excel 365 recursive […]

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

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

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

Vlookup a cell range and return multiple values

VLOOKUP a multi-column range and return multiple values.

VLOOKUP a multi-column range and return multiple values.

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

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

This article explains different techniques that filter rows/records that contain a given text string in any of the cell values […]

This article explains different techniques that filter rows/records that contain a given text string in any of the cell values […]

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