New Posts For Thread: Excel Questionhttps://community.betfair.com/general_betting/go/thread/view/94082/23475526/excel-question=SUMPRODUCT(($A$4:$A$8362=A4)*(H4$H$4:$H$8362))+1The above formula ranks certain cells values from the lowest to the highest. How can i change the formula please so it works in reverse and ranks the cells highest to lowest. Highest no.= 1 etc. ?the formula i posted has come out wrong it missing the more than symbol, just had to change for a less than symbol. simples :)https://community.betfair.com/general_betting/go/thread/view/94082/23475526/excel-question?post_id=419295818#419295818the formula i posted has come out wrong it missing the more than symbol, just had to change for a less than symbol. simples :)Sun, 06 Dec 2009 14:41:46 -0600Cool ,what did it?https://community.betfair.com/general_betting/go/thread/view/94082/23475526/excel-question?post_id=419295814#419295814Cool ,what did it?Sun, 06 Dec 2009 14:37:06 -0600Beats me pal, noot used this formula before, can't you just filter ascending/descending?https://community.betfair.com/general_betting/go/thread/view/94082/23475526/excel-question?post_id=419295810#419295810Beats me pal, noot used this formula before, can't you just filter ascending/descending?Sun, 06 Dec 2009 14:36:47 -0600sorted ;)https://community.betfair.com/general_betting/go/thread/view/94082/23475526/excel-question?post_id=419295806#419295806sorted ;)Sun, 06 Dec 2009 14:35:20 -0600jedyball don't work m8.https://community.betfair.com/general_betting/go/thread/view/94082/23475526/excel-question?post_id=419295802#419295802jedyball don't work m8.Sun, 06 Dec 2009 14:29:15 -0600Thats without looking into the formula in depth so may well be wrong.https://community.betfair.com/general_betting/go/thread/view/94082/23475526/excel-question?post_id=419295798#419295798Thats without looking into the formula in depth so may well be wrong.Sun, 06 Dec 2009 14:20:21 -0600At a guess I'd say switch the "+1" to "-1".https://community.betfair.com/general_betting/go/thread/view/94082/23475526/excel-question?post_id=419295794#419295794At a guess I'd say switch the "+1" to "-1".Sun, 06 Dec 2009 14:19:49 -0600=SUMPRODUCT(($A$4:$A$8362=A4)*(H4$H$4:$H$8362))+1The above formula ranks certain cells values from the lowest to the highest. How can i change the formula please so it works in reverse and ranks the cells highest to lowest. Highest no.= 1 etc. ?https://community.betfair.com/general_betting/go/thread/view/94082/23475526/excel-question?post_id=419295790#419295790=SUMPRODUCT(($A$4:$A$8362=A4)*(H4$H$4:$H$8362))+1The above formula ranks certain cells values from the lowest to the highest. How can i change the formula please so it works in reverse and ranks the cells highest to lowest. Highest no.= 1 etc. ?Sun, 06 Dec 2009 14:17:14 -0600