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 :)
|