Forums

General Betting

Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
Steve Voltage
06 Dec 09 20:17
Joined:
Date Joined: 23 May 09
| Topic/replies: 3,798 | Blogger: Steve Voltage's blog
=SUMPRODUCT(($A$4:$A$8362=A4)*(H4$H$4:$H$8362))+1

The 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. ?
Pause Switch to Standard View Excel Question
Show More
Loading...
Report jedyball December 6, 2009 8:19 PM GMT
At a guess I'd say switch the "+1" to "-1".
Report jedyball December 6, 2009 8:20 PM GMT
Thats without looking into the formula in depth so may well be wrong.
Report Steve Voltage December 6, 2009 8:29 PM GMT
jedyball don't work m8.
Report Steve Voltage December 6, 2009 8:35 PM GMT
sorted ;)
Report jedyball December 6, 2009 8:36 PM GMT
Beats me pal, noot used this formula before, can't you just filter ascending/descending?
Report jedyball December 6, 2009 8:37 PM GMT
Cool ,what did it?
Report Steve Voltage December 6, 2009 8:41 PM GMT
the formula i posted has come out wrong it missing the more than symbol, just had to change for a less than symbol. simples :)
Post Your Reply
<CTRL+Enter> to submit
Please login to post a reply.

Wonder

Instance ID: 13539
www.betfair.com