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
Bu iş için 31 freelancer ortalamada $23 teklif veriyor
Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g Daha Fazla
Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha Daha Fazla
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.
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 i Daha Fazla
"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 you Daha Fazla
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.
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 f Daha Fazla
$ 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.
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.
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 h Daha Fazla
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
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
I have the solving for your problem if nobody solved that for you. just consider me and you will be not dissapointed.
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 posi Daha Fazla
Hello, to answer your questiiom: No there is no function like this. I mean you can work with Count or CountIf but I think that's not what you want. You want tables for the appearancesof 0 and 1. That's only possible w Daha Fazla