Forums

General Betting

There is currently 1 person viewing this thread.
Steve Voltage
06 Dec 09 20:17
Joined:
Date Joined: 23 May 09
| Topic/replies: 3,880 | 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. ?

Post your reply

Text Format: Table: Smilies:
Forum does not support HTML
Insert Photo
Cancel
sort by:
Show
per page
Replies: 7
By:
jedyball
When: 06 Dec 09 20:19
At a guess I'd say switch the "+1" to "-1".
By:
jedyball
When: 06 Dec 09 20:20
Thats without looking into the formula in depth so may well be wrong.
By:
Steve Voltage
When: 06 Dec 09 20:29
jedyball don't work m8.
By:
Steve Voltage
When: 06 Dec 09 20:35
sorted ;)
By:
jedyball
When: 06 Dec 09 20:36
Beats me pal, noot used this formula before, can't you just filter ascending/descending?
By:
jedyball
When: 06 Dec 09 20:37
Cool ,what did it?
By:
Steve Voltage
When: 06 Dec 09 20:41
the formula i posted has come out wrong it missing the more than symbol, just had to change for a less than symbol. simples :)
sort by:
Show
per page

Post your reply

Text Format: Table: Smilies:
Forum does not support HTML
Insert Photo
Cancel
‹ back to topics
www.betfair.com