New Posts For Thread: Excel help pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/23468994/excel-help-pleaseHi : 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 av;)https://community.betfair.com/general_betting/go/thread/view/94082/23468994/excel-help-please?post_id=419145098#419145098;)Wed, 18 Nov 2009 09:57:13 -0600Good work, starfish, ladhttps://community.betfair.com/general_betting/go/thread/view/94082/23468994/excel-help-please?post_id=419145094#419145094Good work, starfish, ladWed, 18 Nov 2009 09:21:21 -0600Perhaps Find function or Search function might be better. Less likely to find the nearest number if the sought for number is not available.https://community.betfair.com/general_betting/go/thread/view/94082/23468994/excel-help-please?post_id=419145090#419145090Perhaps Find function or Search function might be better. Less likely to find the nearest number if the sought for number is not available.Wed, 18 Nov 2009 09:00:43 -0600Specifically it is a MATCH function queryThe answer is =match(a1,$b$1:$b$6,0)...then do some copy and paste to sort out the non-matchesThanks starfish, you're an absolute star(fish)https://community.betfair.com/general_betting/go/thread/view/94082/23468994/excel-help-please?post_id=419145086#419145086Specifically it is a MATCH function queryThe answer is =match(a1,$b$1:$b$6,0)...then do some copy and paste to sort out the non-matchesThanks starfish, you're an absolute star(fish)Wed, 18 Nov 2009 08:46:04 -0600thanks, 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!https://community.betfair.com/general_betting/go/thread/view/94082/23468994/excel-help-please?post_id=419145078#419145078thanks, 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!Wed, 18 Nov 2009 07:47:18 -0600sorry but i know nothing about horses so no idea what you talking aboutmaybe this link helps you... or not http://www.youtube.com/user/ExcelIsFun#p/c/D8EEA7196D943ED5he is the best teacher of excel on youtube (but this new way of youtube presenting phttps://community.betfair.com/general_betting/go/thread/view/94082/23468994/excel-help-please?post_id=419145010#419145010sorry but i know nothing about horses so no idea what you talking aboutmaybe this link helps you... or not http://www.youtube.com/user/ExcelIsFun#p/c/D8EEA7196D943ED5he is the best teacher of excel on youtube (but this new way of youtube presenting pTue, 17 Nov 2009 18:00:14 -0600Nopes : but i hope its understood.. thanks again in advancehttps://community.betfair.com/general_betting/go/thread/view/94082/23468994/excel-help-please?post_id=419145006#419145006Nopes : but i hope its understood.. thanks again in advanceTue, 17 Nov 2009 12:38:55 -0600Thanks .. 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 CBob Tisdallhttps://community.betfair.com/general_betting/go/thread/view/94082/23468994/excel-help-please?post_id=419145002#419145002Thanks .. 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 CBob TisdallTue, 17 Nov 2009 12:38:01 -0600dont know if this is what you need but...copy what you need then paste in excell as text on one single cellhttps://community.betfair.com/general_betting/go/thread/view/94082/23468994/excel-help-please?post_id=419144998#419144998dont know if this is what you need but...copy what you need then paste in excell as text on one single cellTue, 17 Nov 2009 09:19:46 -0600Hi : 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 avhttps://community.betfair.com/general_betting/go/thread/view/94082/23468994/excel-help-please?post_id=419144994#419144994Hi : 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 avTue, 17 Nov 2009 08:37:25 -0600