I'm trying to set up a worksheet to compile stats leaders from several different worksheets (baseball statistics of players from various teams). The catch is that in order to qualify for a league leader in a average category you need to have 3.1 plate appearances per team game played. For example: Player A has 24 plate appearances in 6 team games for a 4.0 plate appearance average. Hence, Player A would qualify for the league leader in average, slugging percentage, etc...Player B has 15 plate appearances in 6 team games for a 2.5 plate appearance average....therefore, Player B would not qualify for the league leaders in the previously mentioned stats. I would like to set up the worksheet to collect the qualified players and transfer their name and average which are located in two different columns per team worksheet. There are 30 team worksheets so data would be compiled from all 30 sheets...Help please!
Bookmarks