Hey guys-
This is a strange one, so I've attatched the spreadsheet to this thread.
Basically, it selects horses for races based on other tipsters choices.
First of all, I go to a website (http://www.gg.com/tips) to get their choice and times of the race for one paticular meeting. I then paste this as text into the "Insert Page" to add the race times and their choice of horse. I input all the tipsters selections, by dignifying their horse name with a 1.
It all works it out, and puts the horse selections into 1st Selections, ready for copying and pasting into a website.
The Sheet 2nd Selections just uses another method of selecting the horses.
It bases the results on the figures in the 'Results' Sheet, which shows how well each tipster has done.
Right- Ideally, what I would like to do is on the first page (enter), once the results come in, I would like to type in a 'W' or a 'L' in the I Column next to the horses whether they have won or lost. It would then scan along the row, and where there was a 1, it would find which tipster had done it, then input this into the results sheet. If it was a W, it would add one onto the Wins, and if it was a L, it would add one onto the Losses.
Cheers,
Sam
Bookmarks