Generally, simple formulas calculate more quickly than array-formulas.
Bob Umlas
Excel MVP
"Dave F" wrote in message
ups.com...
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?