We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
General Betting
There is currently 1 person viewing this thread.
06 Dec 09
20:17
Joined:
Date Joined:
23 May 09
=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. ?
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. ?
sort by:
Show
per page
Replies: 7
|
By:
At a guess I'd say switch the "+1" to "-1".
|
|
By:
Thats without looking into the formula in depth so may well be wrong.
|
|
By:
jedyball don't work m8.
|
|
By:
sorted ;)
|
|
By:
Beats me pal, noot used this formula before, can't you just filter ascending/descending?
|
|
By:
Cool ,what did it?
|
|
By:
the formula i posted has come out wrong it missing the more than symbol, just had to change for a less than symbol. simples :)
|