#1
|
|||
|
|||
Excel Help
The form I use for ratings has up to 10 runs for each horse but I only want to look at the last 3 for part of the rating. I can use a countifs formula to get what I need from all 10 but I want to look at just the last 3 runs. The runs are in rows for each horse (listed alphabetically) showing the most recent run at the top.
If anyone can help it would be appreciated. |
#2
|
|||
|
|||
mattio, i may be able to help but need more information, are you able to email me an example of what your after? You may still have my email address, if not I can post it here again.
|
#3
|
|||
|
|||
Hi Josh,
Thanks, I managed to find a solution to return multiple values from a single VLOOKUP which gave me the data I was looking for. |
#4
|
|||
|
|||
No worries, I was playing with something similar recently. Had a list of distances down 30,000 rows and wanted to sum the profit from each particular distance (i.e. 1000, 1200, etc etc). Took some searching around on google but found a solution. Always amazes me how adaptable Excel can be.
|
#5
|
|||
|
|||
Yeah I am learning new stuff all the time, there are some great sites out there with heaps of info.
|
Thread Tools | Search this Thread |
Display Modes | |
|
|