## Sequence

Excel ยป Sequence ยป

Find the longest/smallest consecutive sequence of a 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 show [โฆ]

Find the longest/shortest consecutive sequence of a value

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

Find a sequence of values โ wildcard search

In my last post I showed you how to find a sequence of values. The array formula extracted the row [โฆ]

This array formula finds the sequence "Axis Chemical Co." (cell E2) and "Southern Railway" (cell E3) in two consecutive cells [โฆ]

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

Excel has a great built-in versatile tool for creating number sequences. In some situations, however, you need to rely on [โฆ]

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 [โฆ]