Forum Discussion
Excel Baseball 1st Batter Out Formula Help
Attached is an example file I use for tracking pitchers statistics. I'm struggling with finding a formula that works for figuring out if the pitcher got the first batter out in the inning. I've s...
Sorry, different accounts there Patrick. That reply was from me, the original author!
I'm not sure if you want the results aggregated and if you need a formula to also determine P (Outcome) automatically. This formula produces a summary of counts the pitcher retired for the first batter for a given inning:
=LET(
crit, (outcome = "K") * (batter = 1) + (outcome = "O") * (batter = 1),
GROUPBY(inning, batter, COUNTA, , , , crit)
)