Pattern Recognition Formula Needed:

Each cell input in the sequence will either be "above", "bellow" or "middle" (only 3 possible variables).

For Example:

CELL A1 = above

CELL A2 = bellow

CELL A3 = bellow

CELL A4 = bellow

CELL A5 = above

CELL A6 = bellow

CELL A7 = middle

CELL A8 = bellow

ETC...

As you can see, the same variable may appear consecutively like CELL A2 through A4. But, it will only / can only appear a maximum of 50 consecutive times.

So, I need someone to create a formula that will identify when two specific patterns occur (independently):

PATTERN #1

Above > Middle > Bellow > Middle > Bellow

PATTERN #2

Bellow > Middle > Above > Middle > Above

But, the formula must take into account when conecutive variables appear. For Example:

CELL A1 = above

CELL A2 = middle

CELL A3 = middle

CELL A4 = bellow

CELL A5 = middle

CELL A6 = bellow

In this sequence PATTERN #2 did actually occur, even though CELL A2 & A3 are consecutive occurances of a single variable.

Another Example:

CELL A1 = above

CELL A2 = middle

CELL A3 = middle

CELL A4 = bellow

CELL A5 = bellow

CELL A6 = bellow

CELL A7 = middle

CELL A8 = middle

CELL A9 = middle

CELL A10 = bellow

In this example PATTERN #2 also occured, even though there where conecutive occurances of the same variable back to back.

Om arbejdsgiveren:
( 1 bedømmelse ) San Pedro de Macorís, Dominican Republic

Projekt ID: #27840305

12 freelancere byder i gennemsnit \$26 timen for dette job

akritisood94

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me.

\$30 USD på 1 dag
(137 bedømmelser)
6.2
(174 bedømmelser)
6.6
daniyal3214

I can perfectly help you with that. I am a professional Google Sheets and Excel expert holding years of experience in utilizing advance level tools and functions of Excel (including VBA and Macro) to perform Data Analy Flere

\$20 USD på 1 dag
(93 bedømmelser)
6.0
braincenter

Hello, Hope this message finds you well, I checked your details and I believe that my experience is what you are looking 4. I have been working on similar projects for the past eight years, and I have the essential sk Flere

\$50 USD på 1 dag
(4 bedømmelser)
4.3
Jayant222

Hi there, I am an expert in google sheets and can help you on this real quick. please connect for details, Thanks, Jay

\$30 USD på 1 dag
(11 bedømmelser)
3.0
Sunitav36

Hi, I have checked the project : Google Sheets Excel Formula Creation I am proficient in excel and i have 9+ Years of experience in Excel, i can make any reports with Automation, data cleaning , data extract, Visuali Flere

\$20 USD in 7 dage
(11 bedømmelser)
3.3
agmahran

Hi, My name is Ayman Mahran. I'm a programmer and an Android developer. I have worked on multiple projects that involve using formulas and macros. I believe I'll be able to help you with your task. If you are intereste Flere

\$30 USD in 2 dage
(1 bedømmelse)
1.5
fafak2006

Hello, I hope you are well in this pandemic situation. I just saw your post, I understand your needs. Well, I’ve interested in your project and I can do this work this for you with all the requirements you have to ask Flere

\$20 USD in 7 dage
(0 bedømmelser)
0.0

Good day, Sir- i seen your project now. and i am interested with your project. I am a skilled Digital Marketer with over 4 years of experience in Digital marketing> Email marketing, SEO,Social Media Marketing . Please Flere

\$10 USD på 1 dag
(0 bedømmelser)
0.0
Nupuurrr

Hi, This is Amy.. Toss your project to me and take it back tomorrow, Let me know if interested. Cheers

\$30 USD in 7 dage
(0 bedømmelser)
0.0
sureshkatla

Hi, First of all, I appreciate you for detailed description of the requirement. I understood it and can complete the job easily. I have extensive experience in google sheets and script. I can give you a formula to id Flere

\$30 USD på 1 dag
(0 bedømmelser)
0.0
tarunS99

Hi, I have 2+ years of experience in IT field, I have completed many tasks similar to this. I am a logic designer and I can done this task if I got a chance. Thankyou.

\$10 USD in 2 dage
(0 bedømmelser)
0.0