Find/search for the sequence 2,3,4 in a column

[Rwtas]

Hi,

I was just wondering if you can use the 'Find & Select' tool to search for a specific sequence of values in a column.

I need to search for the pattern of 2,3,4 down the column.
I don't need to count the number of times this occurs, I only need to be locate the sequence in the data.


Any help would be appreciated
Cheers
Ryan

[cbatrody]

Hi,

Try the following formula in B2:

Please Login or Register  to view this content.

drag it down the cells.

[Rwtas]

That is exactly what I needed thanks

[cbatrody]

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved