Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > General Topics
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 17th October 2013, 06:59 AM
mattio mattio is offline
Member
 
Join Date: Jan 2011
Posts: 268
Default 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.
Reply With Quote
  #2  
Old 17th October 2013, 08:30 AM
evajb001 evajb001 is offline
Member
 
Join Date: Oct 2009
Posts: 463
Default

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.
Reply With Quote
  #3  
Old 17th October 2013, 08:43 AM
mattio mattio is offline
Member
 
Join Date: Jan 2011
Posts: 268
Default

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.
Reply With Quote
  #4  
Old 17th October 2013, 08:48 AM
evajb001 evajb001 is offline
Member
 
Join Date: Oct 2009
Posts: 463
Default

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.
Reply With Quote
  #5  
Old 17th October 2013, 04:21 PM
mattio mattio is offline
Member
 
Join Date: Jan 2011
Posts: 268
Default

Yeah I am learning new stuff all the time, there are some great sites out there with heaps of info.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 09:12 AM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655