Fermé

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.

Compétences : Excel, Traitement de Données, Saisie de Données, Codage

en voir plus : 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

Concernant l'employeur :
( 1 commentaire ) San Pedro de Macorís, Dominican Republic

Nº du projet : #27840305

12 freelances font une offre moyenne de 26 $ pour ce travail

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(137 Commentaires)
6.2
(174 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(93 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(11 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(11 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(1 Évaluation)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
0.0
Nupuurrr

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0