Hello Excel Masters,
I have a problem which I am stuck with.. I have checked the forum and could not find the answer, even though I am quite close with to get the answer with this formula (Count number of times a value appears in role??) I am still looking for suggestion.
So, let's say a have a column with values:
Y
N
Y
Y
Y
N
N
N
I need a formula which would count number of last (not MAX) Ns in a row,- in this case this would be 3
In case of:
Y
Y
Y
N
N
Y
The formula should return 0, because last value is not N
Also would be great if formula could still count a number of last Ns in a row if there's 0s or blanks after Ns. In case of:
Y
N
N
Y
N
N
N
0/Blank
0/Blank
The formula should return 3, because before 0s/Blanks there was 3 consecutive Ns.
Hope the question is clear and someone could help me.
Thanks in advance.
I have a problem which I am stuck with.. I have checked the forum and could not find the answer, even though I am quite close with to get the answer with this formula (Count number of times a value appears in role??) I am still looking for suggestion.
So, let's say a have a column with values:
Y
N
Y
Y
Y
N
N
N
I need a formula which would count number of last (not MAX) Ns in a row,- in this case this would be 3
In case of:
Y
Y
Y
N
N
Y
The formula should return 0, because last value is not N
Also would be great if formula could still count a number of last Ns in a row if there's 0s or blanks after Ns. In case of:
Y
N
N
Y
N
N
N
0/Blank
0/Blank
The formula should return 3, because before 0s/Blanks there was 3 consecutive Ns.
Hope the question is clear and someone could help me.
Thanks in advance.