jbifeelgood
New Member
- Joined
- Jan 9, 2020
- Messages
- 2
- Office Version
- 2019
- Platform
- MacOS
Hi,
I have table tennis match data for 3 people;
Person (1) D3:R3
Person (2) D4:R4
Person (3) D5:R5
Where the values are 2 (win) 1 (draw) and 0 (loss). I would like to calculate the longest win and loss streak for each.
This is also then repeated in D9:R9, D15:R19, D20:R20 (person a), D10:R10, D16:R16, D21:R21 (person b), D11:R11, D17:R17. D22:R2, not sure if it would be possible to include all of these ranges for each person as well?
I have table tennis match data for 3 people;
Person (1) D3:R3
Person (2) D4:R4
Person (3) D5:R5
Where the values are 2 (win) 1 (draw) and 0 (loss). I would like to calculate the longest win and loss streak for each.
This is also then repeated in D9:R9, D15:R19, D20:R20 (person a), D10:R10, D16:R16, D21:R21 (person b), D11:R11, D17:R17. D22:R2, not sure if it would be possible to include all of these ranges for each person as well?