## 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 of the first found sequence, see below.

**Array formula in cell F3:**

Recommended article

Comments(2) Filed in category: Excel, Sequence

What I didn´t show you was how to find multiple sequences with this particular array formula.

This array formula finds all instances of a sequence. It returns their starting row number.

**Array formula in cell F8:**

Recommended article

**Find the longest/smallest consecutive sequence of a value**

Comments(5) Filed in category: Excel, Sequence

### Look for a multi-level sequence

The next array formula looks for a consequtive values in columns and rows. The picture explains it all.

**Array formula in cell H3:**

Use this formula if you are looking for the first instance of a sequence. It looks for a specific sequence (LexCorp and Paradise Airlines) in column A and for 604 and 767 in column B. LexCorp and 604 must be on the same row and Paradise Airlines and 767 must be on the next row below.

This formula is quite small, if you compare it to the following formula.

Recommended article

Comments(14) Filed in category: Excel, Sequence

### Look for multiple multi-level sequences

**Array formula in cell H8:**

It is like the formula above but it returns the location of multiple sequences.

Recommended article

**Locate lookup values in a table [HYPERLINK]**

Comments(14) Filed in category: Excel, Hyperlinks, Vlookup

### Wild card search for a sequence

This demonstrates how to do a wild card search for a sequence. This formula returns the row number of first found sequence in column A. The formula looks for a text string in a cell and another text string in the cell below. You don´t need to enter the wild cards * (asterisks), see cell F3 and F4.

insertexcerpt id="1450"]

### Wild card search for multiple sequences

This demonstrates how to do wild card searches for multiple sequences. This formula returns the row number of all found sequences in column A. The sequence is in cell F11 and F12.

**Array formula in cell G11:**

If a cell contains "Corp" and the next cell beneath contains "Airlines" the array formula returns the row number.

**Search for multiple text strings in multiple cells**

Comments(17) Filed in category: Excel, Search and return multiple values

### Download excel *.xlsx file

Find a sequence of values.xlsx

### Functions in this post

Comments(9) Filed in category: Excel

**SMALL function and LARGE function**

Comments(12) Filed in category: Excel

Comments(12) Filed in category: Excel

Comments(1) Filed in category: Excel

Comments(3) Filed in category: Excel, Search and return multiple values

### Category: Sequence

Comments(14) Filed in category: Excel, Sequence

Create number sequences in excel 2007

Create number sequences (Autofill) Example 1 Type "1" in cell B3 + Enter Right click on black dot and drag […]Comments(9) Filed in category: Excel, Sequence

Sequencing and numbering of batches in excel

Question: I have two volumes which keeps on varying in L1 & L2 head. This is the only info i […]Comments(6) Filed in category: Excel, Sequence

Find the longest/smallest 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 […]Comments(5) Filed in category: 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 […]Comments(3) Filed in category: Excel, Sequence

Comments(2) Filed in category: Excel, Sequence

### One Response to “Find a sequence of values – wildcard search”

### Leave a Reply

**How to add a formula to your comment:**

<code>your formula</code>

**How to add VBA code to your comment:**

[vb 1="vbnet" language=","]

VBA code

[/vb]

**How to add a picture to your comment:**

Upload picture to postimage.org

Add picture link to comment.

**Contact Oscar**

You can contact me through this webpage

[…] ← Previous post - […]