Forums

General Betting

Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
starfish and coffee
17 Nov 09 14:37
Joined:
Date Joined: 03 Sep 08
| Topic/replies: 8,055 | Blogger: starfish and coffee's blog
Hi : how can I match up the Timeform 1-2-3 to the runners on the racecard in my database?

2 sets of columns : one is all the days runners, the other is only those runners rated in the top 3. Obviously they do not correlate side by side so how do I avoid having to enter it all manually?

Thanks in advance
Pause Switch to Standard View Excel help please
Show More
Loading...
Report Lusitano71 November 17, 2009 3:19 PM GMT
dont know if this is what you need but...

copy what you need then paste in excell as text on one single cell
Report starfish and coffee November 17, 2009 6:38 PM GMT
Thanks .. i dont think that would be it

To clarify better ..
In a 6 runner race how to sort columns for Timeform 1-2-3, or ATR Speed ratings which only list the top 3.

A B C
Bob Tisdall Desert Orchid 1
Docklands Express Pegwell Bay 2
Desert Orchid Yahoo 3
Nortons Coin
Pegwell Bay
Yahoo

Obviously I cant sort alpahabetically or by racecard number which I could where there is a rating for each horse in the race

I really really hope this comes out proprerly when I press Post
Report starfish and coffee November 17, 2009 6:38 PM GMT
Nopes : but i hope its understood.. thanks again in advance
Report Lusitano71 November 18, 2009 12:00 AM GMT
sorry but i know nothing about horses so no idea what you talking about

maybe this link helps you... or not

http://www.youtube.com/user/ExcelIsFun#p/c/D8EEA7196D943ED5

he is the best teacher of excel on youtube (but this new way of youtube presenting personal channels is sh!t,i cant find the search function, and this channel has hundreds of videos)
Report starfish and coffee November 18, 2009 1:47 PM GMT
thanks, i'll check out the site

its not really a horse racing query, its an excel sort query and i'm sure someone on the forum knows how to do it!
Report starfish and coffee November 18, 2009 2:46 PM GMT
Specifically it is a MATCH function query

The answer is =match(a1,$b$1:$b$6,0)...then do some copy and paste to sort out the non-matches

Thanks starfish, you're an absolute star(fish)
Report Gitmo November 18, 2009 3:00 PM GMT
Perhaps Find function or Search function might be better. Less likely to find the nearest number if the sought for number is not available.
Report duncan idaho November 18, 2009 3:21 PM GMT
Good work, starfish, lad
Report Lusitano71 November 18, 2009 3:57 PM GMT
;)
Post Your Reply
<CTRL+Enter> to submit
Please login to post a reply.

Wonder

Instance ID: 13539
www.betfair.com