|Subject:||Ranking a number outside of range's values?|
|Posted by:||pompair (timonar…@gmail.com)|
|Date:||31 Jan 2007|
I have in A1:A5 numbers:
If I write =RANK(7;A1:A5;1) the result is rightly 4. This is the rank
for the number 7 in this range.
But what I'd like to do is to find the rank for some number outside of
the range, like 3 for example, how would I do it?
I mean, trying something like: =RANK(3;A1:A5;1) results in #N/A