## 'Sequence' category

Find the most/least consecutive repeated value [VBA]

This postÂ Find the longest/smallest consecutive sequence of a value has a few really big arrayÂ formulas. Today I would like to […]

This postÂ Find the longest/smallest consecutive sequence of a value has a few really big arrayÂ formulas. Today I would like to […]

Extract the most repeated adjacent values in a column

The array formula in cell D3 returnsÂ the the length of longest consecutive sequence of a value in column A. Â Cell […]

The array formula in cell D3 returnsÂ the the length of longest consecutive sequence of a value in column A. Â Cell […]

Search for a sequence of cells based on wildcard search

This article demonstrates array formulas that perform a wildcard search based on a sequence of values. The formulas return the […]

This article demonstrates array formulas that perform a wildcard search based on a sequence of values. The formulas return the […]

Search for a sequence of values

This article demonstrates array formulas that identify two search values in a row or in a sequence. The image above […]

This article demonstrates array formulas that identify two search values in a row or in a sequence. The image above […]

Repeat values across cells

This article explains how to repeat specific values based on a table, the table contains the items to be repeated […]

This article explains how to repeat specific values based on a table, the table contains the items to be repeated […]

Create number series

Excel has a great built-in tool for creating number series named Autofill. The tool is great, however, in some situations, […]

Excel has a great built-in tool for creating number series named Autofill. The tool is great, however, in some situations, […]

How to identify two consecutive dates in a list

Question: How to identify two consecutive dates in a list? Answer: Array formula in cell B1: =IFERROR(LARGE(IF((A1+1)=$A$1:$A$30,A1+1,""),1),"") How to enter […]

Question: How to identify two consecutive dates in a list? Answer: Array formula in cell B1: =IFERROR(LARGE(IF((A1+1)=$A$1:$A$30,A1+1,""),1),"") How to enter […]

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