I would say that whenever possible use the non array version because it's
easier to edit and you can't just chop of 4 rows of an multiple cell array
entered formula

--


Regards,


Peo Sjoblom


"RagDyeR" wrote in message
...
Unless you're going to use thousands of these formulas, or your going to
expand the range to thousands of rows, the difference would be
inconsequential.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"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?