I'm not sure if that was your question. If you were asking about the average skip of the balls that hit that is a different but simpler setup. To do this you need only 6 columns, 1 for each ball and 1 for the Powerball. The formula for Ball 1 would be "=Min(Match(C7,$C8:$C500,0),Match(C7,$D8:$D500,0),Match(C7,$E8:$E500,0),Match(C7,$F8:$F500,0),Match(C7,$G8:$G500,0))".
Copy this formula to the other 5 Columns and to about 200 games from the bottom of your data. The formula will return an error when there is no match in the Array. This gives you the skip of each ball that hits.
Average here would be for the position not the ball.
That's all I got.