+ Reply to Thread
Results 1 to 3 of 3

AutoFiltered Subtotals Permanently Displayed (Baseball Statistics)

  1. #1
    Registered User
    Join Date
    05-08-2014
    MS-Off Ver
    Excel 2003
    Posts
    2

    AutoFiltered Subtotals Permanently Displayed (Baseball Statistics)

    Hello,

    I don't even know how to ask this question properly so please bear with me:

    I am tracking baseball batting statistics. The first column in each row is the player's name and the next column is the date. Several columns of statistics follow. I enter the batting stats game by game. I know I can use the SUBTOTAL function combined with AutoFilter to view each player's statistics individually totalled, but what I'd like is to see that subtotal line permanently displayed for each player. I'm sure this is a pretty basic function in Excel, but I can't even come up with the correct terminology to search for the help I need.

    I'd be grateful for a shove in the right direction.

    Many thanks!

    Bert

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,962

    Re: AutoFiltered Subtotals Permanently Displayed (Baseball Statistics)

    Don't use Autofilter - select your data, sort by name first - other sort levels may be used too - and then on the data tab select SubTotals and choose the settings for what function to use at each change of value in the name column. Then you can click the +/- buttons that show up to the far left of the Excel screen to hide details but allow the Subtotal results to show. I don't have 2003 anymore to give you the exact steps... sorry.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    05-08-2014
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: AutoFiltered Subtotals Permanently Displayed (Baseball Statistics)

    Thanks! I appreciate the help.

    Take care,

    Bert

+ 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. Organizing Baseball Statistics from Multiple Sources
    By par0016 in forum Excel General
    Replies: 1
    Last Post: 01-23-2013, 11:27 AM
  2. Replies: 1
    Last Post: 05-08-2006, 10:25 PM
  3. Replies: 1
    Last Post: 05-08-2006, 04:00 PM
  4. baseball Statistics spreadsheet
    By fkoskotas in forum Excel General
    Replies: 3
    Last Post: 05-02-2006, 02:00 PM
  5. [SOLVED] Baseball statistics
    By enorment in forum Excel General
    Replies: 0
    Last Post: 03-23-2006, 01:35 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