I have a row range, in which I'd like to take into consideration every 3rd cell value in it.
Every third cell can have the following values: 0, 1 or more and empty (I will set it as _ in the examples below)
The valid combinations can be as following:
_
0,_
0,0,_
>0
0,>0
0,0,>0
etc.
I'd like to have the following outcome:
When there are 0 or more 0's with a following empty cell - NA
When there is one >0 - ==> 1
When there are one or more 0's followed by one >0 cell - # of 0's + 1
There cannot be more than one >0 cell, and it is always after (0 or more) zeros.
Examples.
Remember: I am only interested in the values of C, F and I etc.
A B C D E F G H I outcome x x NA x x 0 x x NA x x 0 x x 0 x x NA x x 20 1 x x 0 x x 10 2 x x 0 x x 0 x x 300 3
I hope that the pattern is clear.
Again, for each third cell in a row:
As long as there only empty cells or zeros ==> NA
When there is one >0 cell and before it 0 or more zeroed cells => Number of zeros + 1
I can show you many options I tried, but none worked.
So I'd ask for you assitance.
Bookmarks