Forum Discussion
Excel Baseball 1st Batter Out Formula Help
From what I gather of your request: the outcome essentialy is did the batter reach base or did not reach base (e.g. Struck out, lined out, etc.). The issue is the data is granular so the outcome must be checked across multiple columns to see what happened to the batter. This is do-able with BYROW or even MMULT. Before a formula can be drawn up it would be helpful to note which of the columns are "Out" and which are "Reached base".
I currently don't have a column that represents out or safe. Column P is where you put the result of the at bat. Scrolling over to the right are all my calculations/formula in red that help me do all my data.
I could easily put two more columns amidst that which would dictate an out/negative or safe/positive result. If you look in column BL & BM, you can see I've formatted something that is calculating that for a different situation.
So if I made two separate columns, one would be:
Safe: IF(OR(P2="1B","2B","3B","HR","BB","HBP"),1,0)
Out: IF(OR(P2="K","O","ROE"),1,0)
That would give you what you need for the result of the at bat. Not it is just trying to match that up with the 1st batter of each inning. Any ideas on how to do that now?