I have a table that ranks a list of players by their statistics, for example,
when I change cell B2 to "walks", my formula (large) lists the player with
the most walks in cell B4, 2nd most in B5, 3rd in B6... that works well
because more walks are good. But, when I change cell B2 to "strikeouts" I
want it to list the player with the fewest number of strikeouts in B4, next
fewest in B5 and so on.

Is there a way to change the "large" function to the "small" function within
the formula?

I have set up a helper cell (C2) that changes from "large" when I have
"walks" in B2 to "small" when I have "strikeouts" in B2.