RANK function
Is there any advantage to using rank as a non-array formula, as in
=RANK(A1,$A$1:$A$18) (entered in B1 and filled down to B18)?
Ordinarily I would use it as an array formula: {=RANK(A1:A18,A1:A18)}
However the documentation I have recently seen on this function
suggests using it in a non-array manner.
Thoughts?
|