Find Jobs
Hire Freelancers

Excel Expert

$10-30 USD

Closed
Posted over 4 years ago

$10-30 USD

Paid on delivery
Hi there, I have been struggling to find function for this problem. I have a set of randoms of 0 and 1s. With this sequence sometimes a zero can occur 3 times in a row, 4 times in a row, or more. The same applies for 1s. Is there a function that could help me determine how many times a value (0 or 1) appears 3, 4, 5 or more times in a row? Please see the attached file
Project ID: 22342637

About the project

30 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
30 freelancers are bidding on average $23 USD for this job
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$30 USD in 1 day
4.9 (437 reviews)
7.8
7.8
User Avatar
"Hi, I am good in your required project; I also have a great working experience of more than 10 years. To ensure please visit my profile and check customers satisfaction level. I will complete your project within your given deadline. Thank you. "
$25 USD in 1 day
4.9 (332 reviews)
7.6
7.6
User Avatar
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. Look at the comments that employers have left me, that is my greatest satisfaction. Best regards
$30 USD in 1 day
4.9 (286 reviews)
7.2
7.2
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing to take up your project. Thank you, Regards.
$20 USD in 1 day
5.0 (134 reviews)
6.6
6.6
User Avatar
$ 15 Only ------ In just 1 Hour ------ Excel Data Management, VBA Macro Coding, Formula Generation and Automation Expert ---- I can make a VBA program to find 0s & 1s.
$15 USD in 1 day
5.0 (188 reviews)
6.0
6.0
User Avatar
I have rich experience in excel (Advanced formulas, Charts, Forms, VBA, Macro,....), and I do my best to save your time and pocket. Please feel free to contact me. Services: # Accuracy # Customer satisfaction is my first "Priority" # Time Commitment # Availability Thanks, Shahin
$20 USD in 1 day
4.4 (55 reviews)
5.7
5.7
User Avatar
Hi There. I have your solution ready. I can give you a user defined function that will do this for you. It will identify any consecutive data in a column and put the count at the first instance. Regards. Reuben
$20 USD in 1 day
5.0 (19 reviews)
4.9
4.9
User Avatar
Dear Sir, I am extremely good with Excel as it is part of my daily professional work. Working with complicated formula and Developing Macro programs are part of my daily deliverable. I am a professional accountant graduated with major in Finance and Accounts along with 8 years of experience in Finance, Accounting, Taxation and Auditing. I believe I can do a fantastic work for you if you provide me the opportunity. Sincerely, Gopal
$20 USD in 7 days
5.0 (15 reviews)
4.6
4.6
User Avatar
Hey there, I see you’re looking for someone to create formula to calculate number of times special condtions (2 times 0/1, 3 times 0/1..etc.) > Send me more details so we can go further. Give me one chance to give my service and make you Happy. I`m ready to create history with you!. Feel free to contact me anytime.
$15 USD in 2 days
5.0 (21 reviews)
4.5
4.5
User Avatar
I have the solving for your problem if nobody solved that for you. just consider me and you will be not dissapointed.
$15 USD in 1 day
5.0 (32 reviews)
4.7
4.7
User Avatar
I'm experienced MS excel expert with 05 yrs of experience in the field. I have done multiple successful projects on and I can help.
$10 USD in 1 day
4.3 (19 reviews)
4.9
4.9
User Avatar
Hi, my name is José. I would like we discuss details on chat because something seems not to have much sense. I might be wrong, however in the terms you describe the problem you will never find a function that could help you determine how many times a value (0 or 1) appears 3, 4, 5 or more times in a row. The reason is very simple, they are the result of the odds, because as you said in the post they are random numbers. Don´t hesitate to contact me if you have questions. Regards... JoseH
$10 USD in 1 day
4.9 (7 reviews)
4.1
4.1
User Avatar
Hi, I can help you in project. We can make a web based application to check the counts for 0 or 1s. Please let me know when we can discuss in more details so that we could proceed further. I do work on following skillsets: php, mysql, codeigniter, laravel, wordpress, jquery, google map, angular. Looking forward for your response. Thanks. Kind Regards.
$70 USD in 2 days
5.0 (3 reviews)
3.7
3.7
User Avatar
--- I can give you a custom function as macro/vba which can determine how many time a value (0 or 1) appears ---- i already advance for that .
$30 USD in 7 days
4.7 (2 reviews)
4.0
4.0
User Avatar
I have read your project and I am an expert in this field. I can do this for you within due time and honestly. I also have a few questions to discuss. Kindly contact me and we will discuss time and budget. Thanks
$20 USD in 7 days
4.8 (8 reviews)
3.1
3.1
User Avatar
I do fast work on my project. you can trust me. and give me a chance to prove my work ability.I very interested in your project.
$20 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i have huge experience in working with these projects. If you need sample work just send me a message. Waiting for your quick reply.
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I've previously worked on this type of projects. Please See My Profile. I'll quickly enter data Perfectly. .I've understood your requirement very clearly. Your work will be delivered on time that's a guarantee. As I'm an Experienced Operator you'll get perfect work from me. Ready to start working. Please contact me in message.
$10 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
en excel existen funciones o formulaciones para contar los datos repetidos por columnas o filas, yo le puedo hacer la revisión de las repeticiones sin que me tome tanto tiempo, además me encanta trabajar en excel me siento muy cómoda.
$20 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Sir, I can handle English language in a casual manner with excellent communication skills ability to work with in MS Office, ability to plan schedule & resource managing willingness to work hard and also rich with positive attitudes. I am able to complete your project as soon as possible on time and I have also more than 2 year experience about data entry. I have all facility to fulfil your project and also have good speed of typing English. Thank You!
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SOUTH AFRICA
Cape Town, South Africa
0.0
0
Member since Nov 15, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.