Closed

Google Sheets Excel Formula Creation

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.

Skills: Excel, Data Processing, Data Entry, Coding

See more: google sheets complex formulas, google sheets formulas pdf, google sheets formulas if, how to insert formula in google sheets for entire column, useful google sheets formulas, how to add equation to graph in google sheets, google sheets formulas sum, google sheets formulas cheat sheet, i have an excel spreadsheet that needs some final touches to be ready i need an absolute expert at working an excel, google sheets, excel, google sheets, excel, google forms, google sheets autofill formula, google sheets hyperlink formula, google sheets timesheet formula, google sheets array formula examples, google sheets array formula vlookup, google sheets array formula filter, google sheets array formula if, google sheets excel compatibility, google sheets array formula

About the Employer:
( 1 review ) San Pedro de Macorís, Dominican Republic

Project ID: #27840305

12 freelancers are bidding on average $26 for this 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 in 1 day
(137 Reviews)
6.2
(174 Reviews)
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 More

$20 USD in 1 day
(93 Reviews)
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 More

$50 USD in 1 day
(4 Reviews)
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 in 1 day
(11 Reviews)
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 More

$20 USD in 7 days
(11 Reviews)
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 More

$30 USD in 2 days
(1 Review)
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 More

$20 USD in 7 days
(0 Reviews)
0.0
mdzihadali

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 More

$10 USD in 1 day
(0 Reviews)
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 days
(0 Reviews)
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 More

$30 USD in 1 day
(0 Reviews)
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 days
(0 Reviews)
0.0