New Posts For Thread: Excel Formula Help pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/24006577/excel-formula-help-pleaseHiI want to assess ratings using the second ranked as the index markerE.g with a set of ratings thus:-105100959391The toprated will have an index value of 105, second rated 100 then 95,93,91 73, 72, 70, 64, 63 would return 101, 100, 97, 89, 88What wothat will do, cheershttps://community.betfair.com/general_betting/go/thread/view/94082/24006577/excel-formula-help-please?post_id=432770661#432770661that will do, cheersMon, 10 May 2010 10:32:38 -0500Just replace the AD's to A didn't like my last post for some reasonhttps://community.betfair.com/general_betting/go/thread/view/94082/24006577/excel-formula-help-please?post_id=432770265#432770265Just replace the AD's to A didn't like my last post for some reasonMon, 10 May 2010 10:29:23 -0500=ROUND(((A1-LARGE($A$1:$A$10,2))+LARGE($A$1:$A$10,2))/LARGE($A$1:$A$10,2)*100,0)https://community.betfair.com/general_betting/go/thread/view/94082/24006577/excel-formula-help-please?post_id=432770189#432770189=ROUND(((A1-LARGE($A$1:$A$10,2))+LARGE($A$1:$A$10,2))/LARGE($A$1:$A$10,2)*100,0)Mon, 10 May 2010 10:28:40 -0500This should work, probably be able to shorten it though :)=ROUND(((A1-LARGE($A$1:$A$10,2))+LARGE($AD$1:$AD$10,2))/LARGE($AD$1:$AD$10,2)*100,0)Just copy and paste it down your list assuming the first cell is A1 and the range of values in A1:A10https://community.betfair.com/general_betting/go/thread/view/94082/24006577/excel-formula-help-please?post_id=432770061#432770061This should work, probably be able to shorten it though :)=ROUND(((A1-LARGE($A$1:$A$10,2))+LARGE($AD$1:$AD$10,2))/LARGE($AD$1:$AD$10,2)*100,0)Just copy and paste it down your list assuming the first cell is A1 and the range of values in A1:A10Mon, 10 May 2010 10:27:57 -0500have a look at the LARGE function i.e. large(A1:A10,2) will give you the 2nd largest value in the range A1:A10. Should be simple enough to take the values away from that to do what you needhttps://community.betfair.com/general_betting/go/thread/view/94082/24006577/excel-formula-help-please?post_id=432768865#432768865have a look at the LARGE function i.e. large(A1:A10,2) will give you the 2nd largest value in the range A1:A10. Should be simple enough to take the values away from that to do what you needMon, 10 May 2010 10:18:46 -0500HiI want to assess ratings using the second ranked as the index markerE.g with a set of ratings thus:-105100959391The toprated will have an index value of 105, second rated 100 then 95,93,91 73, 72, 70, 64, 63 would return 101, 100, 97, 89, 88What wohttps://community.betfair.com/general_betting/go/thread/view/94082/24006577/excel-formula-help-please?post_id=432767509#432767509HiI want to assess ratings using the second ranked as the index markerE.g with a set of ratings thus:-105100959391The toprated will have an index value of 105, second rated 100 then 95,93,91 73, 72, 70, 64, 63 would return 101, 100, 97, 89, 88What woMon, 10 May 2010 10:08:47 -0500