Forum Discussion
JackP326
Apr 16, 2020Copper Contributor
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 o...
JackP326
Apr 16, 2020Copper Contributor
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.
SergeiBaklan
Apr 16, 2020Diamond Contributor
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.
- JackP326Apr 16, 2020Copper Contributor
- SergeiBaklanApr 16, 2020Diamond Contributor
Please find it in the Sheet2 of the attached file.
- JackP326Apr 16, 2020Copper Contributor