Posts by Laura Garnham
-
-
-
Oh sorry, I did not expect you to guess that. I know the data has an odd structure (I'm not responsible for that, I'm just trying to analyse it...). I was not aware the several instances of counts would be a problem, as I thought where the counting started and stopped would depend on where you pasted the formula. In case it is not clear, I want a separate count for each ID. I am sorry that I am not clear sometimes, I have very little stats/excel/data analysis education so it is hard to describe what I want sometimes...
Thank you. -
-
I did as you asked, file attached.
Sorry, I can see why you misunderstood my rules, hopefully in the attached file it is clearer now what I want, I want to know how many ones there are between the first 2 consecutive ones and the first six consecutive zeros, there may be other consecutive ones or zeros that are in the section being counted, but I only want to count the ones.
Thanks so much for helping me with this. -
-
-
Hi,
I have an excel column that consists of a 1s or 0s like so: 1 1 1 0 1 1 1 1 0 0 1 0 0 0 0 0 0 1 1 1 1 1. I would like to be able to count how many 1s there are after there are 2 consecutive 1s and before 6 consecutive 0s (so in this case I would get a result of 6).
I have to do this for about 200 columns so a formula that automatically does this would be really useful. Please can you tell me if it possible to do this, and, if so, how?
Thanks very much for your help.