hei
i use the betfairpromo.com files , will it be possible to filter the uk horses by favoritism
does anyone know of an excel formula to do this? or any ideas?
Filter favoritism
-
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
Depends how many files/races you're trying to handle. Excel isn't the best for those type of queries much better off using a database , mysql is very good and free or you might already have access if you've office.
Are you trying to extract favourites of simply put the data files in odds order, have a look at the subtotal option under data if you want to extract favs, just use min. Alternatively use sort to first sort by evenitd then SP's
Are you trying to extract favourites of simply put the data files in odds order, have a look at the subtotal option under data if you want to extract favs, just use min. Alternatively use sort to first sort by evenitd then SP's
I was trying to extract the favorites and I used the subtotal as you suggested and it worked for the 1 favorite and for the others and it is possible to extract them ?spreadbetting wrote: ↑Wed Aug 12, 2020 3:47 pmDepends how many files/races you're trying to handle. Excel isn't the best for those type of queries much better off using a database , mysql is very good and free or you might already have access if you've office.
Are you trying to extract favourites of simply put the data files in odds order, have a look at the subtotal option under data if you want to extract favs, just use min. Alternatively use sort to first sort by evenitd then SP's
thx for the help
my excel is like this