Hi All
I require a formula that counts the word "win" if it happens in an occurance from the righthand side.
In the below example the word "Win" appears 3 times however I need the result to be 2 as the formula should dictace that the "Win" in cell J2 is the last in the sequence, and counting backwards from the right that it appears consequative in cells J2 and I2 therefore the result is 2.
If cell K2 is "Win" then the result should change to 3. However if cell K2 says "Lost" then the result will then go back to 0.
I hope this makes sense.
Thanks in advance.
I require a formula that counts the word "win" if it happens in an occurance from the righthand side.
In the below example the word "Win" appears 3 times however I need the result to be 2 as the formula should dictace that the "Win" in cell J2 is the last in the sequence, and counting backwards from the right that it appears consequative in cells J2 and I2 therefore the result is 2.
If cell K2 is "Win" then the result should change to 3. However if cell K2 says "Lost" then the result will then go back to 0.
I hope this makes sense.
Thanks in advance.