Find Jobs
Hire Freelancers

Google Sheets Excel Formula Creation

$10-30 USD

已关闭
已发布超过 3 年前

$10-30 USD

货到付款
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.
项目 ID: 27840305

关于此项目

11提案
远程项目
活跃3 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
11威客以平均价$26 USD来参与此工作竞价
用户头像
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 在1天之内
4.9 (160条评论)
6.4
6.4
用户头像
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 Analysis, Data Visualization, Financial Analysis, Financial Modeling and various types of Analysis, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project.
$20 USD 在1天之内
4.7 (111条评论)
6.3
6.3
用户头像
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 skills including; Data Processing Data Entry Excel Coding I will prove to be of great help to you. SEND MESSAGE/CHAT, so that discuss more on the details including budget and deadlines… Please REMEMBER to; Wash your hands frequently, Maintain social distancing, Avoid touching eyes, nose and mouth..., Practice respiratory hygiene, Stay home and if you feel unwell seek medical care early. Regards, BrainCenter Inc
$50 USD 在1天之内
5.0 (4条评论)
4.3
4.3
用户头像
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 在1天之内
4.8 (14条评论)
3.5
3.5
用户头像
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 identify sequences as per you requirement (considering consecutive occurrences). There are multiple ways to achieve it, formula depends on how you want me to show the result to you. Ping me to discuss further. Look forward to work with you.
$30 USD 在1天之内
5.0 (4条评论)
3.5
3.5
用户头像
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, Visualization Dashboards and i shall give you 100% accuracy with timely deliver the project. To proceed further, I am ready to discuss your project and start immediately. Thanks
$20 USD 在7天之内
4.4 (11条评论)
3.3
3.3
用户头像
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 interested, please send me a message so that we can discuss more. Thanks,
$30 USD 在2天之内
5.0 (2条评论)
2.4
2.4
用户头像
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 send me a message so that we can discuss more. waiting for your kind responds ,Thanks you
$10 USD 在1天之内
0.0 (0条评论)
0.0
0.0
用户头像
Hi, This is Amy.. Toss your project to me and take it back tomorrow, Let me know if interested. Cheers
$30 USD 在7天之内
1.0 (1条评论)
0.8
0.8
用户头像
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 在2天之内
0.0 (0条评论)
0.0
0.0

关于客户

DOMINICAN REPUBLIC的国旗
San Pedro de Macorís, Dominican Republic
5.0
1
付款方式已验证
会员自9月 25, 2014起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。