Spotting Boards 107: Extracting situational statistics and building the board

Create formulas on your spotting board that can immediately scan scraped data for the nuggets you want

In previous lessons at Spotting Board U, we’ve already shown you how to scrape data off the internet to pull something like a schedule for a basketball team.

Now that we have that data, how can you get Google Sheets to scan that data to immediately provide situational context? Like, a team’s record in one possession games? Or a team’s record in two possession games?

All of that can be done by using one simple formula: