My friends and I have a spreadsheet for a game we play and we would like to determine the streak everyone is on, including negative streaks (losing streaks). Here's how it's formatted:
https://spreadsheets.google.com/pub?...=0&output=html
Game | Winner
1 David
2 David
3 Witten
4 Robert
5 Marcus
6 Marcus
We then have stats for each player in columns, for example:
Name: David | Witten | Robert | Marcus
Average: 8 9 10 7
Streak: -4 -3 -2 +2
We want the streak calculated automatically based on the list of winners.
Thanks!
Bookmarks