If you are by your computer, you may want to open this Google Sheet to understand the example discussed in this episode. I walk through a rather long formula involving the FREQUENCY(), COLUMN(), MAX(), and the ARRAYFORMULA() functions in Google Sheets. Here’s the full formula below to calculate win streaks in the Google Sheet: [crayon-5e9a5d15b7f0f403479039/] […]

The post Dear Analyst Episode 22: Calculate win streaks for a pool of players in Google Sheets appeared first on .

Subscribe at alchen.substack.com