General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
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. ?
Show More
Thats without looking into the formula in depth so may well be wrong.
Beats me pal, noot used this formula before, can't you just filter ascending/descending?
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
Please login to post a reply.
Wonder
Instance ID: 13539