General Betting
There is currently 1 person viewing this thread.
17 Nov 09
14:37
Joined:
Date Joined:
03 Sep 08
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
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
sort by:
Show
per page
Replies: 9
|
By:
dont know if this is what you need but...
copy what you need then paste in excell as text on one single cell |
|
By:
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 |
|
By:
Nopes : but i hope its understood.. thanks again in advance
|
|
By:
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) |
|
By:
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! |
|
By:
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) |
|
By:
Perhaps Find function or Search function might be better. Less likely to find the nearest number if the sought for number is not available.
|
|
By:
Good work, starfish, lad
|
|
By:
;)
|