</SPAN></SPAN>Hello,</SPAN></SPAN>
I am looking a specific solution for my need, Count "0" after all specific numbers are listed in cells F5:F24 and result of count show in the cells G5:G24 as shown in the example below...</SPAN></SPAN>
In the data Column D number of sequence is broken by 0's (some time after 1, some time after 2...and so on) I need to count 0's after each sequence has come up (to make example clearer I have filled a different coloured for the last number of each sequence) </SPAN></SPAN>
Here is an example.... with results</SPAN></SPAN>
Thanks In Advance </SPAN></SPAN>
Using version 2000</SPAN></SPAN>
Regards,</SPAN></SPAN>
Moti</SPAN>
I am looking a specific solution for my need, Count "0" after all specific numbers are listed in cells F5:F24 and result of count show in the cells G5:G24 as shown in the example below...</SPAN></SPAN>
In the data Column D number of sequence is broken by 0's (some time after 1, some time after 2...and so on) I need to count 0's after each sequence has come up (to make example clearer I have filled a different coloured for the last number of each sequence) </SPAN></SPAN>
Here is an example.... with results</SPAN></SPAN>
| Book1 | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | |||||||||
| 2 | |||||||||
| 3 | |||||||||
| 4 | n1 | Count "0" After | Count Result | ||||||
| 5 | 0 | 1 | 3 | ||||||
| 6 | 1 | 2 | 2 | ||||||
| 7 | 0 | 3 | 1 | ||||||
| 8 | 1 | 4 | 1 | ||||||
| 9 | 2 | 5 | 3 | ||||||
| 10 | 3 | 6 | 0 | ||||||
| 11 | 4 | 7 | 0 | ||||||
| 12 | 5 | 8 | 0 | ||||||
| 13 | 6 | 9 | 0 | ||||||
| 14 | 8 | 10 | 0 | ||||||
| 15 | 9 | 11 | 0 | ||||||
| 16 | 11 | 12 | 1 | ||||||
| 17 | 12 | 13 | 0 | ||||||
| 18 | 0 | 14 | 0 | ||||||
| 19 | 0 | 15 | 0 | ||||||
| 20 | 2 | 16 | 0 | ||||||
| 21 | 0 | 17 | 1 | ||||||
| 22 | 0 | 18 | 0 | ||||||
| 23 | 1 | 19 | 0 | ||||||
| 24 | 2 | 20 | 0 | ||||||
| 25 | 4 | ||||||||
| 26 | 5 | ||||||||
| 27 | 0 | ||||||||
| 28 | 0 | ||||||||
| 29 | 0 | ||||||||
| 30 | 1 | ||||||||
| 31 | 2 | ||||||||
| 32 | 4 | ||||||||
| 33 | 0 | ||||||||
| 34 | 2 | ||||||||
| 35 | 3 | ||||||||
| 36 | 4 | ||||||||
| 37 | 5 | ||||||||
| 38 | 0 | ||||||||
| 39 | 0 | ||||||||
| 40 | 1 | ||||||||
| 41 | 0 | ||||||||
| 42 | 1 | ||||||||
| 43 | 2 | ||||||||
| 44 | 3 | ||||||||
| 45 | 4 | ||||||||
| 46 | 5 | ||||||||
| 47 | 6 | ||||||||
| 48 | 7 | ||||||||
| 49 | 9 | ||||||||
| 50 | 10 | ||||||||
| 51 | 11 | ||||||||
| 52 | 12 | ||||||||
| 53 | 14 | ||||||||
| 54 | 16 | ||||||||
| 55 | 17 | ||||||||
| 56 | 0 | ||||||||
| 57 | 1 | ||||||||
| 58 | 2 | ||||||||
| 59 | 3 | ||||||||
| 60 | 0 | ||||||||
| 61 | 0 | ||||||||
| 62 | 2 | ||||||||
| 63 | 0 | ||||||||
| 64 | 1 | ||||||||
| 65 | 0 | ||||||||
| 66 | 1 | ||||||||
| 67 | 2 | ||||||||
| 68 | 3 | ||||||||
| 69 | 4 | ||||||||
| 70 | 5 | ||||||||
| 71 | 0 | ||||||||
| 72 | 1 | ||||||||
Sheet1 | |||||||||
Thanks In Advance </SPAN></SPAN>
Using version 2000</SPAN></SPAN>
Regards,</SPAN></SPAN>
Moti</SPAN>
Last edited:
