https://community.betfair.com/general_betting/go/thread/view/94082/27497033/open-office-spreadsheet-help-pleaseI want to rank the runners in a race by their forecast odds but not in a conventional manner.E.g. Horse A 4/1, Horse B 11/2, Horse C 11/2, Horse D 13/2, Horse E 8/1, Horse F 8/1, Horse G 10/1.In the above example one would expect to see Horse A = Rahttps://community.betfair.com/general_betting/go/thread/view/94082/27497033/open-office-spreadsheet-help-please?post_id=493459433#493459433dogrelataSorry, I didn't see your suggestion - it appears we both submitted posts at 14:56; directly after which I logged out. I tried your solution first but the shortest priced runner in the second race was returning the same ranking figure as theSat, 23 Apr 2011 14:17:13 -0500https://community.betfair.com/general_betting/go/thread/view/94082/27497033/open-office-spreadsheet-help-please?post_id=493435537#493435537Back again with improved formula ~=IF(ISBLANK(E2);"";IF(OR(ISBLANK(H1);ISTEXT(H1));1;IF(E1=E2;H1;H1+1)))That formula in cell H2 and filled down for all racesCheers.Sat, 23 Apr 2011 09:35:58 -0500https://community.betfair.com/general_betting/go/thread/view/94082/27497033/open-office-spreadsheet-help-please?post_id=493432473#493432473Ooops. Sorry Compound Magic, I've just noticed you got there first!Sat, 23 Apr 2011 08:57:20 -0500https://community.betfair.com/general_betting/go/thread/view/94082/27497033/open-office-spreadsheet-help-please?post_id=493432373#493432373Thanks for the advice Compound Magic - I was hoping you'd see the thread! Just off to watch some football but I'll give your suggestion a go after the final whistle.All the best.Sat, 23 Apr 2011 08:56:04 -0500https://community.betfair.com/general_betting/go/thread/view/94082/27497033/open-office-spreadsheet-help-please?post_id=493432369#493432369Leave row 1 blank. In cells A2 to A8 (or whatever) put your forecast odds in ascending order. Then in cells B2 to B8 (or whatever) put the following formula, =IF(A2>A1,B1+1,B1).Sat, 23 Apr 2011 08:56:03 -0500https://community.betfair.com/general_betting/go/thread/view/94082/27497033/open-office-spreadsheet-help-please?post_id=493431325#493431325Hi top2ratedYou could do this if your prices in column E are sorted, lowest to highest ~In cell H2 enter 1In cell H3 enter =IF(E2=E3;H1;H1+1)Fill down H3 for the rest. When you get to your next race just copy H2 and H3 and fill down from the second pSat, 23 Apr 2011 08:41:58 -0500https://community.betfair.com/general_betting/go/thread/view/94082/27497033/open-office-spreadsheet-help-please?post_id=493415753#493415753DickyMThanks for your reply.You're right about the RANK function but I need a means of ensuring those 'subsequent numbers' only increase in increments of 1.Sat, 23 Apr 2011 03:48:24 -0500https://community.betfair.com/general_betting/go/thread/view/94082/27497033/open-office-spreadsheet-help-please?post_id=493414973#493414973Hi t2r, I think using the RANK function in column H may be close to what you want, this gives duplicate numbers for the same rank, but subsequent numbers would increase so Checkerboard in your 1st race would be 4 not 3Sat, 23 Apr 2011 03:26:01 -0500https://community.betfair.com/general_betting/go/thread/view/94082/27497033/open-office-spreadsheet-help-please?post_id=493413681#493413681I tend to save as and then make liberal use of the undo button when attempting new things on spreadsheets. I am sure you can crack it.Sat, 23 Apr 2011 02:47:32 -0500https://community.betfair.com/general_betting/go/thread/view/94082/27497033/open-office-spreadsheet-help-please?post_id=493413109#493413109Cheers Alex but even with my limited knowledge of excel/open office calc, I realise that your suggestion won't have the desired effect.Thanks anyway.Sat, 23 Apr 2011 02:33:03 -0500