+ Reply to Thread
Results 1 to 2 of 2

How to analyse data in spreadsheet

  1. #1
    Registered User
    Join Date
    01-29-2009
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    15

    How to analyse data in spreadsheet

    Hi,

    I am a horse racing fan and have kept an Excel Spread sheet of all my bets for the past year or so.

    I have about 39 columns which all require inputs. I am struggling to find a quick way to analyse and so laboriously have to data sort at present and add up columns to determine how many winners a certain jockey or trainer have in certain types of races and how my bets have stacked up for those given jockeys, trainers and certain types of races.

    Any idea how I can in a separate worksheet start to input Jockey A) eg Tony McCoy, and then extract the analysis I need. I have tried some of the @ functions but have not as yet found the right one for my purpose.

    also is it possible ultimately to have an input sheet where I can actually input a jockey or trainer over a given range and it retuns all the stats for that person within certain criteria?
    Many thanks in advance.

    I am a bit of a novice but have mastered the inputting side with a pretty table etc but now desperately need to start interrogting as I am sure it will improve my betting to be able to identify the races, jockeys etc where I have been doing well and then screen out those where I consistently lose money.

    Many thanks
    rav

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: How to analyse data in spreadsheet

    Hi,

    Without a doubt you need to use the Data Pivot Table Report functionality, which is designed to do exactly what you want. Just ensure the data is consitently laid out in a neat two dimensional matrix with column labels in a single row which is the first row of the data matrix.

    Any problems just put some data together in a workbook and upload it so that we can take a look.

    Rgds
    HTH
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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