+ Reply to Thread
Results 1 to 2 of 2

Produce a report from a data file

  1. #1
    Registered User
    Join Date
    02-10-2013
    Location
    Oregon
    MS-Off Ver
    Excel 2003
    Posts
    7

    Produce a report from a data file

    I have a workout file for high school and would like to produce a report by individual

    eg: List all matthews workouts

    see below
    date code name workout

    6/12/2013 h5 matthew 89 57.3 26.5 13
    6/14/2013 h7 matthew 26.5 58.2 27.5 58
    6/17/2013 17 matthew 62 62 63 60
    6/17/2013 55 olivia 71 37/ 75 36/ 77 34
    6/17/2013 55 sarah 68 34/ 69 32/ 70 32
    6/28/2013 1 olivia 5.43 4.30 2.54 78
    6/28/2013 mj sarah 65 31 31 60
    7/1/2013 h7 sarah 31.5 67 31.2 67.6
    7/1/2013 m8 olivia 4.17 58/ 4.26 59
    2/19/2014 37 camden 75 65 61 48 38 25 15/ dns 60 55 46 36 24 16
    2/19/2014 37 chris 57 46 39 30 20 13/ 67 58 50 puke 29 13
    2/19/2014 37 claire 85 78 65 56 47 33 18/ knee - jogged
    2/19/2014 37 ethan 70 59 47 38 32 21 13/ dnf
    2/19/2014 37 hadley 77 64 56 46 36 24 17/ 78 70 60 48 38 27 17
    2/19/2014 37 jessica 77 64 56 46 36 24 17/ 78 69 58 47 36 26 16
    2/19/2014 37 matthew 56 43 34 27 19 13/ 58 52 44 34 28 13
    2/19/2014 37 olivia b 77 64 56 46 35 24 17/ 78 68 56 45 36 26 16
    2/19/2014 37 piper 81 68 60 47 37 26 17/ 80 68 58 47 37 26 17
    2/19/2014 37 scotty 73 61 51 41 31 22 15/ 70 63 53 42 33 22 15
    2/19/2014 37 tyler 70 59 47 38 30 21 13/ 67 57 48 36 29 13
    2/26/2014 12 ben 50 50 52 56 59/ 3.10
    2/26/2014 12 chris 47 48 48 47 46/ 2.17

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 VersionVersion 2501 Win 11
    Posts
    24,432

    Re: Produce a report from a data file

    If your field names are in Row 1, Highlight the fieldnames, click on Data, Filter, AutoFilter

    Now on the field with the names, from the drop down, select Matthew.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Excel spreadsheet to produce a report per row
    By bankcott in forum Excel General
    Replies: 15
    Last Post: 02-23-2014, 11:11 AM
  2. [SOLVED] Extract specific data from a report and re-produce cleaner output
    By SVTF in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 09-22-2013, 11:59 PM
  3. Replies: 1
    Last Post: 07-15-2012, 05:50 PM
  4. Using Excel to produce a report
    By Sinking Ship in forum Excel General
    Replies: 5
    Last Post: 09-22-2011, 07:53 PM
  5. [SOLVED] Produce a report in specific layout from varying data
    By Maff2002 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-20-2009, 04:56 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