Forum Discussion
Help and Old Man Out Please
I have attached a worksheet that illustrates the two problems that I am having. The spreadsheet has comments in cells that shows what I am trying to accomplish. The spreadsheet is just an example of the real life spreadsheet which is several thousands of rows (and more to be added) and 60 columns that need to do this equation. Feel free to add as many columns as needed to solve the problem but the solution needs to be contained in each row.
My Grandson ( the smartest person in my family) couldn't solve the problem and he is my only resource. Any help would be greatly appreciated.
Thanks in Advance
Jack
14 Replies
Jack, variant of calculations is in next columns:
In E14
=--(A14=1)in F14
=IFNA(IF(E14,MATCH(1,INDEX(E:E,ROW()+1):E$1000,0)-1,""),"")and drag them down till end of range.
In F2
=COUNTIF(F$14:$F$1000,LEFT(E2,SEARCH(" ",E2)-1))and also drag it down.
Sergie
Thank you so much for your quick response. Let me ask is it possible for the calculation to be at the bottom as an example have the 4 that I had in C14 be located at C19? In addition when I tried your solution for F2 and I dragged down it didn’t result in any totals is just put 0 in the cell.
Let me clarify - you'd like count of zeroes against next 1 (yellow) or against last zero (blue) in the series?
Formula in F2 works on column F, not on column C, perhaps you didn't adjust it.
