New Posts For Thread: Help needed : 2 questions for the Excel boyshttps://community.betfair.com/general_betting/go/thread/view/94082/23512866/help-needed-2-questions-for-the-excel-boysand girls of course.1. I want columns to show difference from MAX, for ratings, odds, weights etc. E.g 140 136 137 138 129 will return 0,4,3,2,11 This step is easy =(MAX($A$1:$a$5)-CELL) But what if I want to show the points clear of second-rated forCheers guys much appreciated.https://community.betfair.com/general_betting/go/thread/view/94082/23512866/help-needed-2-questions-for-the-excel-boys?post_id=420136886#420136886Cheers guys much appreciated.Fri, 12 Feb 2010 15:25:46 -0600Compound Magic .. thanks for your suggestion! I'll try to run through it later. Very glad to have got very workable solutions to my post.Gelding, hope that works for you. If you ever want any input on how you are sorting out and using your data youhttps://community.betfair.com/general_betting/go/thread/view/94082/23512866/help-needed-2-questions-for-the-excel-boys?post_id=420136846#420136846Compound Magic .. thanks for your suggestion! I'll try to run through it later. Very glad to have got very workable solutions to my post.Gelding, hope that works for you. If you ever want any input on how you are sorting out and using your data youFri, 12 Feb 2010 10:08:12 -0600If the first line of data is in cell A1 in a blank column enter this formula in the same row=RIGHT(A1,2)fill down as neededHighlight all the data in column A and the column with the formulaand then do a sort by the column with the formula in it, sorthttps://community.betfair.com/general_betting/go/thread/view/94082/23512866/help-needed-2-questions-for-the-excel-boys?post_id=420136834#420136834If the first line of data is in cell A1 in a blank column enter this formula in the same row=RIGHT(A1,2)fill down as neededHighlight all the data in column A and the column with the formulaand then do a sort by the column with the formula in it, sortFri, 12 Feb 2010 08:30:37 -0600guys, sorry for hijacking the thread but I have a similar problem with my ratings.All the ratings are downloaded into each race meeting but they are not in order, ir highest to lowest.What I am currently doing is highlighting each race and using sorthttps://community.betfair.com/general_betting/go/thread/view/94082/23512866/help-needed-2-questions-for-the-excel-boys?post_id=420136830#420136830guys, sorry for hijacking the thread but I have a similar problem with my ratings.All the ratings are downloaded into each race meeting but they are not in order, ir highest to lowest.What I am currently doing is highlighting each race and using sortFri, 12 Feb 2010 07:43:52 -0600For Question 1, I can't improve on Lori's formulaCheershttps://community.betfair.com/general_betting/go/thread/view/94082/23512866/help-needed-2-questions-for-the-excel-boys?post_id=420136790#420136790For Question 1, I can't improve on Lori's formulaCheersFri, 12 Feb 2010 05:28:40 -0600Typo error should be=RANK(B1,$B$1:$B$5)+COUNTIF($B$1:B1,B1)-1https://community.betfair.com/general_betting/go/thread/view/94082/23512866/help-needed-2-questions-for-the-excel-boys?post_id=420136782#420136782Typo error should be=RANK(B1,$B$1:$B$5)+COUNTIF($B$1:B1,B1)-1Fri, 12 Feb 2010 05:08:06 -0600Question 2 formula ~=RANK(B1,$B$1:$B$5,)+COUNTIF($B$1:B1,B1)-1Just having a look at question 1Cheershttps://community.betfair.com/general_betting/go/thread/view/94082/23512866/help-needed-2-questions-for-the-excel-boys?post_id=420136778#420136778Question 2 formula ~=RANK(B1,$B$1:$B$5,)+COUNTIF($B$1:B1,B1)-1Just having a look at question 1CheersFri, 12 Feb 2010 05:06:39 -0600snap, and a couple of points below top ratedhttps://community.betfair.com/general_betting/go/thread/view/94082/23512866/help-needed-2-questions-for-the-excel-boys?post_id=420136758#420136758snap, and a couple of points below top ratedFri, 12 Feb 2010 03:28:03 -0600:^0It's just a shame that I'm actually really crud at excel and have to wangle things to get them to work.https://community.betfair.com/general_betting/go/thread/view/94082/23512866/help-needed-2-questions-for-the-excel-boys?post_id=420136754#420136754:^0It's just a shame that I'm actually really crud at excel and have to wangle things to get them to work.Fri, 12 Feb 2010 03:25:29 -0600Please accept my thanks as a donation to the Lori 24hr Excel Helpdesk Benevolent Foundationhttps://community.betfair.com/general_betting/go/thread/view/94082/23512866/help-needed-2-questions-for-the-excel-boys?post_id=420136746#420136746Please accept my thanks as a donation to the Lori 24hr Excel Helpdesk Benevolent FoundationFri, 12 Feb 2010 03:23:58 -0600