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