Kapalı

Excel Expert

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

Beceriler: Excel, Veri İşleme, Matematik

Daha fazlasını gör: i need an infographic designed based on the attached content - 5 tips for buying a used car, i need an infographic designed based on the attached content 5 tips for buying a used car, i want to hire an excel expert in the leesburg va area, looking to get a web banner designed immediately for my websites landing page please see the attached document to fully understa, please design around the attached bootstrap psd for responsiveness, excel expert in the philippines, Hello. I would like you to make two logos for a company. Please open the attached document to view the logo instructions., To build a website for IT consultancy (please check the attached document)., Convert the attached spreadsheet to EXCEL. Add to columns for Trade and Trade Sub-Category eg under Concrete supply add a column, Please read through the attached document , hi, we are designing a new sales lead generation website like the attached and looking for ideas, look forward to seeing the des, hi, please see attached excel document showing the 11 pages i , please find the attached file as per your request, please find the attached file for your review, please find the attached file for your reference, please kindly find the attached file, please take a look at the attached file and let me know, please review the attached document and let me know if you have any suggestions for improvement, please review the attached document and let me know, please find the attached file for your perusal

İşveren Hakkında:
( 0 değerlendirme ) Cape Town, South Africa

Proje NO: #22342637

Bu iş için 31 freelancer ortalamada $23 teklif veriyor

jaylancer43

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(729 Değerlendirme)
8.5
schoudhary1553

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(330 Değerlendirme)
7.9
P0L

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(334 Değerlendirme)
7.3
elqueabandona

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(230 Değerlendirme)
6.9
datakillers

"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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(208 Değerlendirme)
6.9
periyannas

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(108 Değerlendirme)
6.3
shahinrahimi

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(42 Değerlendirme)
4.8
GopalJp

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 accounta Daha Fazla

$20 USD in 7 gün içinde
(14 Değerlendirme)
4.6
AnowarRatul

$ 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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(42 Değerlendirme)
4.4
chraheelbhatti

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(13 Değerlendirme)
4.2
HERNANDEZJB

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(4 Değerlendirme)
3.5
royalwebraisers

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 ski Daha Fazla

$70 USD in 2 gün içinde
(3 Değerlendirme)
3.6
umairali8062

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 gün içinde
(8 Değerlendirme)
3.0
chetandc

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 Daha Fazla

$15 USD in 2 gün içinde
(18 Değerlendirme)
2.7
reubengi

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
1.1
MartinDudumi

I have the solving for your problem if nobody solved that for you. just consider me and you will be not dissapointed.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
0.3
wageesha9812

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
UEmanuel

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
jatin1241998

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 gün içinde
(0 Değerlendirme)
0.0
NAHID2596

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 gün içinde
(0 Değerlendirme)
0.0