+ Reply to Thread
Results 1 to 6 of 6

Count Instances or Frequency multiple sheets - Counting position appearances in baseball

  1. #1
    Registered User
    Join Date
    10-28-2008
    Location
    Chicago
    MS-Off Ver
    MS365 - 2211
    Posts
    94

    Count Instances or Frequency multiple sheets - Counting position appearances in baseball

    I help coach youth baseball and young kids.

    In our rec league, I try my best to ensure that kids play 2-3 positions a game, split between the infield and outfield. I have a nice, refined sheet I made to create a lineup card for each game. I'm very happy with that.

    Attached is a workbook that has that template and 8 game worksheets. I have one worksheet that I want to summarize or count the number of instances a kid has played a given position across the season. I tried getting help on this once here and got something that was close and I think I messed up. I'm hoping someone can help me out a bit.

    My main goal is to have something I can quickly look at and see little Jimmy or whoever has not played position X or another kid has played a disproportionate amount at one position or another.

    I likely would add additional sheets, so any help to make sure that if I duplicate a sheet, it doesn't cause too many errors would be very appreciated.

    Thanks,
    Matt

  2. #2
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Count Instances or Frequency multiple sheets - Counting position appearances in baseba

    I upgraded your formulas as much as I could.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    As you add new sheets you also change the number 8, since it is an array formula you adjust just one time.
    Don't let the 'Roster' table with empty rows.
    Attached Files Attached Files
    Last edited by DJunqueira; 03-22-2024 at 05:01 PM.

  3. #3
    Registered User
    Join Date
    10-28-2008
    Location
    Chicago
    MS-Off Ver
    MS365 - 2211
    Posts
    94

    Re: Count Instances or Frequency multiple sheets - Counting position appearances in baseba

    Thanks for this, that helps a lot. I like the little graphics as well!

  4. #4
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Count Instances or Frequency multiple sheets - Counting position appearances in baseba

    Tks for the feedback, glad to have helped.

  5. #5
    Registered User
    Join Date
    10-28-2008
    Location
    Chicago
    MS-Off Ver
    MS365 - 2211
    Posts
    94

    Re: Count Instances or Frequency multiple sheets - Counting position appearances in baseba

    Actually, I believe it is finding something that is not right in that search.

    For some reason, regardless of anything, every position filled seems to get filled as that position on the summary AND as an inning-playing C. I put in the kids' names, and I have one kid playing 3 innings at 1B and RCF. Both populate right, but in addition to that, he shows himself with 6 innings at C. I'm not sure if I did something wrong or not. Unfortunately, what you put in there is a bit above my current skill level in Excel.

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,563

    Re: Count Instances or Frequency multiple sheets - Counting position appearances in baseba

    This proposal utilizes power query and a pivot table.
    1. Convert the range A9:K22 on each game sheet into an Excel table.
    2. Name each Excel table tbl_Game# (as in tbl_Game1, tbl_Game2).
    Note that I did this for games 1 and 2. I will leave the remaining games for you.
    3. Use power query to produce a table (green/white) for all games using:
    Please Login or Register  to view this content.
    4. Produce a pivot table from the green/white table.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. [SOLVED] A counting formula that won't count multiple instances of same val
    By Dave Peterson in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 09-06-2005, 07:05 AM
  2. [SOLVED] A counting formula that won't count multiple instances of same val
    By Dave Peterson in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-06-2005, 06:05 AM
  3. [SOLVED] A counting formula that won't count multiple instances of same val
    By Watercolor artist in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  4. A counting formula that won't count multiple instances of same val
    By Watercolor artist in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  5. A counting formula that won't count multiple instances of same val
    By Watercolor artist in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  6. [SOLVED] A counting formula that won't count multiple instances of same val
    By Watercolor artist in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. A counting formula that won't count multiple instances of same val
    By Watercolor artist in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  8. [SOLVED] A counting formula that won't count multiple instances of same val
    By Watercolor artist in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-14-2005, 11:05 AM

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