J Jez Mar 3, 2004 #1 How can I use the Rank function in reverse? i.e. if I have a list of figures, the lowest being the best should be ranked 1.
How can I use the Rank function in reverse? i.e. if I have a list of figures, the lowest being the best should be ranked 1.
F Frank Kabel Mar 3, 2004 #2 Hi try the following (if A1:A100 stores your values) =RANK(A1,$A$1:$A$100,1) this uses the third parameter of the RANK function
Hi try the following (if A1:A100 stores your values) =RANK(A1,$A$1:$A$100,1) this uses the third parameter of the RANK function
