+ Reply to Thread
Results 1 to 3 of 3

Baseball Stats

  1. #1
    Registered User
    Join Date
    08-01-2014
    Location
    Coldwater, Michigan
    MS-Off Ver
    2007 Excel
    Posts
    1

    Baseball Stats

    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!

  2. #2
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Baseball Stats

    Can you post a sample sheet demonstrating what you're trying to accomplish?

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Baseball Stats

    You could copy all of the info to one sheet, and then sort and filter.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Input box for an array for baseball stats
    By baseball fanatic in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-31-2014, 09:22 AM
  2. Trying to access tables and stats from Baseball Reference
    By arsenal123gunners in forum Excel General
    Replies: 1
    Last Post: 06-24-2010, 11:27 AM
  3. Baseball stats?
    By Nissi in forum Excel General
    Replies: 2
    Last Post: 05-13-2010, 10:37 AM
  4. Analyzing Baseball Stats
    By madmanmac in forum Excel General
    Replies: 1
    Last Post: 10-26-2006, 03:15 PM
  5. Baseball Stats question: How can I get the RBI's?
    By AVERAGE(user) in forum Excel General
    Replies: 7
    Last Post: 10-25-2005, 03:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1