Forum Discussion

  • arsene49's avatar
    arsene49
    Helper I
    3 years ago

    Thanks Ahmed for the logic.

    i checked the logic but your logic is not working for couple of scenarois like if there are continiuos 4 Wins (it is counting as 2)

    ex. for below data, it is showing count as 2 which is wrong. it should be 1

    also it shows 4 when there are 6 continious W .instead it should show 2

     

    1Batman   L
    2Batman   W
    3Batman   W
    4Batman   L
    5Batman   W
    6Batman   W
    7Batman   W
    8Batman   W
      • arsene49's avatar
        arsene49
        Helper I
        3 years ago

        Thanks much Ahmed for this refined logic.

         

        this is not working for below scenario - 

        if some has won 6/9 times continiously (WWWWWW), it still shows 1. instead it should show 2/3.

         

        it would be great if you can accomodate this scenario in your formula. appreciate your help on this.