S
Sam Hamman
Hi, I have a query which is a bit complicated to say the least (well
at least for me anyway
.
I have a spreadsheet which contains the results from horse races run
in the United Kingdom from May 2011 to date.
Each day the day's races are downloaded into the spreadsheet and what
I would like to be able to do is as follows:
1) For each horse I would like to have a cell next to it which looks
up a master table which contains all of the previous results and
populates the cell with previous results data which meet certain
criteria. So for example:
Cell A
Horse name
Cell B
Track name
Cell C
Ideally this would be populated with previous run history at track. So
the formula would look up the master table and search the horse name
cell. where it finds a match the formula then searches track cell in
the master table and if it finds a match again only then would it look
to the results cell, take that data and populate Cell C.
The outcome
Lets say the horse has run three times at the track and has the
following results 1, 4, 10 this being in date order (date also on
master table, if need) as the last three runs. Cell B would be
populated and formatted as follows: 1-4-10
If that is possible I would like to be able to extend the
functionality so that I could add in other criteria. For example, the
history of the horse and jockey combination, or the horse at a certain
distance.
Thanks very much in advance.
Sam
at least for me anyway
.I have a spreadsheet which contains the results from horse races run
in the United Kingdom from May 2011 to date.
Each day the day's races are downloaded into the spreadsheet and what
I would like to be able to do is as follows:
1) For each horse I would like to have a cell next to it which looks
up a master table which contains all of the previous results and
populates the cell with previous results data which meet certain
criteria. So for example:
Cell A
Horse name
Cell B
Track name
Cell C
Ideally this would be populated with previous run history at track. So
the formula would look up the master table and search the horse name
cell. where it finds a match the formula then searches track cell in
the master table and if it finds a match again only then would it look
to the results cell, take that data and populate Cell C.
The outcome
Lets say the horse has run three times at the track and has the
following results 1, 4, 10 this being in date order (date also on
master table, if need) as the last three runs. Cell B would be
populated and formatted as follows: 1-4-10
If that is possible I would like to be able to extend the
functionality so that I could add in other criteria. For example, the
history of the horse and jockey combination, or the horse at a certain
distance.
Thanks very much in advance.
Sam